APPS.PAY_GB_RTI_FPS_VALIDATE_13 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 796: FROM pay_payroll_actions ppa, pay_assignment_actions paa

792:
793: -- To fetch Effective date
794: CURSOR get_effective_date IS
795: SELECT ppa.effective_date
796: FROM pay_payroll_actions ppa, pay_assignment_actions paa
797: WHERE ppa.payroll_action_id = paa.payroll_action_id
798: AND paa.assignment_action_id = p_assactid;
799:
800: --Declarations

Line 1326: FROM pay_payroll_actions ppa, pay_assignment_actions paa

1322:
1323: -- To fetch Effective date
1324: CURSOR get_effective_date IS
1325: SELECT ppa.effective_date
1326: FROM pay_payroll_actions ppa, pay_assignment_actions paa
1327: WHERE ppa.payroll_action_id = paa.payroll_action_id
1328: AND paa.assignment_action_id = p_assactid;
1329:
1330: --Declarations

Line 1894: pay_assignment_Actions paa ,

1890: when others then
1891: -- fetch the details using asg action id
1892: hr_utility.set_location('Getting from asg_act_id' ,2);
1893: select paaf.assignment_number,papf.sex into l_assignment_number,l_gender from per_all_assignments_f paaf,
1894: pay_assignment_Actions paa ,
1895: per_all_people_f papf where
1896: paa.assignment_action_id = p_assactid
1897: and paa.assignment_id = paaf.assignment_id
1898: and paaf.person_id = papf.person_id

Line 2372: ,pay_assignment_actions paa

2368: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
2369: /*ppa.effective_date*/
2370: sysdate
2371: from pay_payroll_actions ppa
2372: ,pay_assignment_actions paa
2373: where paa.assignment_action_id = c_assignment_action_id
2374: and ppa.payroll_action_id = paa.payroll_action_id;
2375:
2376: l_date_valid DATE;