CREATE OR REPLACE FUNCTION APPS.HR_GET_DEPENDENT(p_element_entry_id IN NUMBER, p_contact_number IN NUMBER, p_data_field IN VARCHAR2) RETURN VARCHAR2 IS l_contact_name VARCHAR2(300); CURSOR C1 IS SELECT DEP.Full_Name Contact_Full_Name, DEP.National_Identifier,…
Read MoreCREATE OR REPLACE FUNCTION APPS.Aging_Bucket_Due (P_CUST_ACCOUNT_ID IN NUMBER, P_AGING_BUCKET IN NUMBER) RETURN NUMBER IS l_bucket_balance NUMBER(10,2); BEGIN…
Read MoreSELECT gp.period_name, (SELECT ‘Q’ || quarter_num || ‘-WK’ …
Read MoreSELECT pcdl.prvdr_gl_period_name ei_latest_gl_period_name, gcc.segment1 r_company, peia.revenue_recognized_flag ei_revenue_distributed_flag, ppat.NAME ei_project_name, ppab.segment1 ei_project_number, pet.expenditure_type_name ei_expenditure_type, pec.expenditure_category_name ei_expenditure_category,…
Read MoreReverse charge is a mechanism where the recipient of the goods and/or services is liable to pay GST instead of the supplier. Normally, the supplier of goods or services pays…
Read MoreThis report will display all project unbilled details. SELECT ppa.project_id, ppa.segment1 project_number, NVL ((SELECT pt.project_type FROM pjf_project_types_tl pt, pjf_projects_all_vl…
Read MorePurpose of the report is to display project hours and hard-limit amount with interactive mode. with XXANSR_PA_EVENTS_cte as (SELECT evt.ROWID as “ROW_ID”, evt.event_id as “EVENT_ID”,…
Read MorePurpose of this report is to derive all projects expenditure and event details with cost information. SELECT revenue_type, TO_CHAR (customer_id) customer_id, customer_name, TO_CHAR (project_id) project_id, project_number,…
Read MoreThis query fetches the details of those assets which are partially and fully depreciated. SELECT ASSET_CATEGORY_ID ,MAJOR_CATEGORY ,OPENING_DAY_ASSET_COST ,OPEN_ACC_ASSET_COST_FY …
Read More