APPS.PAY_GB_RTI_FPS_VALIDATE dependencies on PAY_PAYROLL_ACTIONS

Line 96: from pay_payroll_actions pact,

92: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
93: nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
94: hoi.org_information7 econ,
95: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIN_SUB'),1,20) final_submission
96: from pay_payroll_actions pact,
97: hr_organization_information hoi
98: where pact.payroll_action_id=pactid
99: and pact.business_group_id = hoi.organization_id
100: and hoi.org_information_context = 'Tax Details References'

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 2357: from pay_payroll_actions ppa

2353: cursor csr_parameter_info is
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: