APPS.CREATE_GB_RTI_EPS_RECORD dependencies on PAY_GB_EPS

Line 195: FROM PAY_GB_EPS_DETAILS

191: --Check if already EPS record exists for PAYE reference and Effective date combination
192: CURSOR c_check_eps
193: IS
194: SELECT 1
195: FROM PAY_GB_EPS_DETAILS
196: WHERE EFFECTIVE_DATE = l_eff_start_date
197: AND EMP_PAYE_REFERENCE = p_paye_reference
198: AND BUSINESS_GROUP_ID = p_business_group_id;
199:

Line 289: IF PAY_GB_EPS.validate(P_PAYE_REFERENCE, G_ACC_REF_NO, G_EMPLOYERS_NAME, G_ECON_NUMBER, G_RELATED_TAX_YEAR)=1 THEN

285: l_nic_smp_rate :=0;
286: END IF;
287:
288: --Bug 13955276: Call to Validation of Econ Number, PAYE reference
289: IF PAY_GB_EPS.validate(P_PAYE_REFERENCE, G_ACC_REF_NO, G_EMPLOYERS_NAME, G_ECON_NUMBER, G_RELATED_TAX_YEAR)=1 THEN
290: IF L_CALCULATE_SSP OR L_CALCULATE_SMP THEN
291: --Either SSP or SMP calculate should be true.
292: FOR I IN c_lat_assignment_actions
293: LOOP

Line 348: pay_gb_eps.INSERT_EPS_RECORD ( L_EFF_START_DATE, P_PAYE_REFERENCE, G_ACC_REF_NO, p_business_group_id, G_EMPLOYERS_NAME, G_ECON_NUMBER, G_RELATED_TAX_YEAR, G_SMP_SAP_RATE, G_SSP_RATE, G_NIC_RATE, G_SERVICE_PROVIDER,

344: fetch csr_get_request_details into l_request_rec;
345: close csr_get_request_details;
346:
347: --Insert EPS record
348: pay_gb_eps.INSERT_EPS_RECORD ( L_EFF_START_DATE, P_PAYE_REFERENCE, G_ACC_REF_NO, p_business_group_id, G_EMPLOYERS_NAME, G_ECON_NUMBER, G_RELATED_TAX_YEAR, G_SMP_SAP_RATE, G_SSP_RATE, G_NIC_RATE, G_SERVICE_PROVIDER,
349: 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', L_CREATER_ID, G_APPROVER_ID ,
350: FND_GLOBAL.CONC_REQUEST_ID,l_request_rec.PROGRAM_APPLICATION_ID,l_request_rec.CONCURRENT_PROGRAM_ID,l_request_rec.LAST_UPDATE_DATE);
351:
352: