APPS.PAY_GB_RTI_FPS_VALIDATE_13 dependencies on PAY_PAYROLL_ACTIONS

Line 82: from pay_payroll_actions pact,

78: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
79: nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
80: hoi.org_information7 econ,
81: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIN_SUB'),1,20) final_submission
82: from pay_payroll_actions pact,
83: hr_organization_information hoi
84: where pact.payroll_action_id=pactid
85: and pact.business_group_id = hoi.organization_id
86: and hoi.org_information_context = 'Tax Details References'

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

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