DBA Data[Home] [Help]

APPS.PAY_IE_LE_MIGRATE dependencies on PAY_ALL_PAYROLLS_F

Line 392: FROM pay_all_payrolls_f pap,

388: CURSOR c_get_payroll_details(p_bg_id NUMBER,p_tax_ref VARCHAR2,p_paye_ref VARCHAR2) IS
389: SELECT scl.id_flex_num id_flex_num,scl.segment2 segment2,
390: scl.segment1 segment1,scl.segment3 segment3,
391: pap.*
392: FROM pay_all_payrolls_f pap,
393: hr_soft_coding_keyflex scl
394: WHERE pap.business_group_id = p_bg_id
395: AND pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
396: AND scl.segment1 = p_tax_ref

Line 418: FROM pay_all_payrolls_f papf

414:
415: -- Cursor to fetch non-migrated P45 actions
416: CURSOR c_get_prl_p35_details(p_bg_id number,p_tax_unit_id number) IS
417: SELECT papf.payroll_id,papf.payroll_name,papf.effective_start_date,papf.effective_end_date
418: FROM pay_all_payrolls_f papf
419: ,hr_soft_coding_keyflex hsck
420: WHERE papf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
421: AND papf.business_group_id = p_bg_id
422: AND hsck.segment4 = to_char(p_tax_unit_id);