APPS.PAY_GB_RTI_FPS_VALIDATE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 783: FROM pay_payroll_actions ppa, pay_assignment_actions paa

779:
780: -- To fetch Effective date
781: CURSOR get_effective_date IS
782: SELECT ppa.effective_date
783: FROM pay_payroll_actions ppa, pay_assignment_actions paa
784: WHERE ppa.payroll_action_id = paa.payroll_action_id
785: AND paa.assignment_action_id = p_assactid;
786:
787: --Declarations

Line 1313: FROM pay_payroll_actions ppa, pay_assignment_actions paa

1309:
1310: -- To fetch Effective date
1311: CURSOR get_effective_date IS
1312: SELECT ppa.effective_date
1313: FROM pay_payroll_actions ppa, pay_assignment_actions paa
1314: WHERE ppa.payroll_action_id = paa.payroll_action_id
1315: AND paa.assignment_action_id = p_assactid;
1316:
1317: --Declarations

Line 1881: pay_assignment_Actions paa ,

1877: when others then
1878: -- fetch the details using asg action id
1879: hr_utility.set_location('Getting from asg_act_id' ,2);
1880: select paaf.assignment_number,papf.sex into l_assignment_number,l_gender from per_all_assignments_f paaf,
1881: pay_assignment_Actions paa ,
1882: per_all_people_f papf where
1883: paa.assignment_action_id = p_assactid
1884: and paa.assignment_id = paaf.assignment_id
1885: and paaf.person_id = papf.person_id

Line 2358: ,pay_assignment_actions paa

2354: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
2355: /*ppa.effective_date*/
2356: sysdate
2357: from pay_payroll_actions ppa
2358: ,pay_assignment_actions paa
2359: where paa.assignment_action_id = c_assignment_action_id
2360: and ppa.payroll_action_id = paa.payroll_action_id;
2361:
2362: l_date_valid DATE;