APPS.PAY_CA_RL2_AMEND_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 32: pay_payroll_actions ppa

28: CURSOR mag_amend_rl2_transmitter IS
29: SELECT 'BUSINESS_GROUP_ID=C',ppa.business_group_id,
30: 'PAYROLL_ACTION_ID=P',MAX(ppa.payroll_action_id)
31: FROM hr_organization_information hoi,
32: pay_payroll_actions ppa
33: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
34: AND hoi.org_information_context='Prov Reporting Est'
35: AND ppa.report_type = 'CAEOY_RL2_AMEND_PP' -- RL2 Amendment Archiver Report Type
36: AND to_char(hoi.organization_id) = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)

Line 56: FROM pay_payroll_actions ppa,

52: SELECT DISTINCT
53: 'BUSINESS_GROUP_ID=C',ppa.business_group_id,
54: 'PAYROLL_ACTION_ID=C',MAX(ppa.payroll_action_id),
55: 'PAYROLL_ACTION_ID=P',MAX(ppa.payroll_action_id)
56: FROM pay_payroll_actions ppa,
57: hr_organization_information hoi
58: WHERE decode(hoi.org_information3,'Y',to_char(hoi.organization_id) ,hoi.org_information20) =
59: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
60: AND hoi.org_information_context='Prov Reporting Est'

Line 89: pay_payroll_actions ppa,

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

Line 91: pay_payroll_actions ppa_arch

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