DBA Data[Home] [Help]

APPS.CREATE_GB_RTI_EPS_RECORD_13 dependencies on FND_GLOBAL

Line 321: where request_id = FND_GLOBAL.CONC_REQUEST_ID;

317: GROUP BY assignment_id;
318:
319: cursor csr_get_request_details is
320: select PROGRAM_APPLICATION_ID,CONCURRENT_PROGRAM_ID,LAST_UPDATE_DATE from fnd_concurrent_requests
321: where request_id = FND_GLOBAL.CONC_REQUEST_ID;
322:
323: l_request_rec csr_get_request_details%rowtype;
324:
325: BEGIN

Line 361: -- L_CREATER_ID := FND_GLOBAL.USER_ID;

357: END IF;
358: CLOSE c_check_eps;
359: GET_GLOBALS;
360: G_RELATED_TAX_YEAR := TO_CHAR(L_DATE_EOY,'YYYY');
361: -- L_CREATER_ID := FND_GLOBAL.USER_ID;
362: select EMPLOYEE_ID INTO L_CREATER_ID FRom FND_USER
363: WHERE USER_ID = FND_GLOBAL.USER_ID;
364: HR_UTILITY.TRACE(' CREATER_ID '||L_CREATER_ID);
365: l_nic_ssp_rate := G_NIC_RATE;

Line 363: WHERE USER_ID = FND_GLOBAL.USER_ID;

359: GET_GLOBALS;
360: G_RELATED_TAX_YEAR := TO_CHAR(L_DATE_EOY,'YYYY');
361: -- L_CREATER_ID := FND_GLOBAL.USER_ID;
362: select EMPLOYEE_ID INTO L_CREATER_ID FRom FND_USER
363: WHERE USER_ID = FND_GLOBAL.USER_ID;
364: HR_UTILITY.TRACE(' CREATER_ID '||L_CREATER_ID);
365: l_nic_ssp_rate := G_NIC_RATE;
366: L_NIC_SMP_RATE := G_NIC_RATE;
367: IF g_ssp_recovery = 'None' THEN

Line 458: L_CREATER_ID, G_APPROVER_ID , FND_GLOBAL.CONC_REQUEST_ID,l_request_rec.PROGRAM_APPLICATION_ID,l_request_rec.CONCURRENT_PROGRAM_ID,l_request_rec.LAST_UPDATE_DATE);

454: --Insert EPS record
455: pay_gb_eps_13.INSERT_EPS_RECORD ( L_EFF_START_DATE, P_PAYE_REFERENCE, G_ACC_REF_NO, p_business_group_id, G_EMPLOYERS_NAME, G_ECON_NUMBER,
456: G_RELATED_TAX_YEAR,l_final_submission_ceased,l_final_submission_year, G_SMP_SAP_RATE, G_SSP_RATE, G_NIC_RATE, G_SERVICE_PROVIDER,
457: l_smp/100, l_sap/100, l_spp/100, l_aspp/100, l_ssp/100, L_NIC_SMP/100, l_nic_sap/100, l_nic_spp/100, l_nic_aspp/100, L_NIC_SSP/100, 'Saved',
458: L_CREATER_ID, G_APPROVER_ID , FND_GLOBAL.CONC_REQUEST_ID,l_request_rec.PROGRAM_APPLICATION_ID,l_request_rec.CONCURRENT_PROGRAM_ID,l_request_rec.LAST_UPDATE_DATE);
459:
460:
461: HR_UTILITY.TRACE(' EPS record insert complete ');
462: --Write Output Information