APPS.PAY_CA_T4A_AMEND_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 16: pay_payroll_actions ppa

12: 'SBMT_REF_ID=P',
13: to_char(max(ppa.payroll_action_id))
14: FROM
15: hr_organization_information hoi,
16: pay_payroll_actions ppa
17: WHERE hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')
18: AND hoi.org_information_context = 'Fed Magnetic Reporting'
19: AND ppa.report_type = 'CAEOY_T4A_AMEND_PP'
20: AND hoi.organization_id = pycadar_pkg.get_parameter('TRANSFER_GRE'

Line 42: pay_payroll_actions ppa,

38: to_char(max(ppa.payroll_action_id))
39: FROM
40: ff_archive_items fai,
41: ff_database_items fdi,
42: pay_payroll_actions ppa,
43: pay_assignment_actions aa,
44: hr_organization_information hoi1,
45: hr_organization_information hoi2
46: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 88: pay_payroll_actions ppa,

84: per_all_people_f ppf,
85: per_all_assignments_f paf,
86: pay_action_interlocks pai,
87: pay_assignment_actions paa,
88: pay_payroll_actions ppa,
89: pay_assignment_actions paa_arch,
90: pay_payroll_actions ppa_arch
91: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
92: AND paa.payroll_action_id = ppa.payroll_action_id

Line 90: pay_payroll_actions ppa_arch

86: pay_action_interlocks pai,
87: pay_assignment_actions paa,
88: pay_payroll_actions ppa,
89: pay_assignment_actions paa_arch,
90: pay_payroll_actions ppa_arch
91: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
92: AND paa.payroll_action_id = ppa.payroll_action_id
93: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
94: AND pai.locking_action_id = paa.assignment_action_id