APPS.PAY_CA_RL2_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 50: pay_payroll_actions ppa

46: CURSOR mag_rl2_transmitter IS
47: SELECT 'BUSINESS_GROUP_ID=C',ppa.business_group_id,
48: 'PAYROLL_ACTION_ID=P',ppa.payroll_action_id
49: FROM hr_organization_information hoi,
50: pay_payroll_actions ppa
51: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
52: AND hoi.org_information_context='Prov Reporting Est'
53: AND ppa.report_type = 'RL2' -- RL2 Archiver Report Type
54: AND to_char(hoi.organization_id) =

Line 73: FROM pay_payroll_actions ppa,

69: SELECT DISTINCT
70: 'BUSINESS_GROUP_ID=C',ppa.business_group_id,
71: 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id,
72: 'PAYROLL_ACTION_ID=P',ppa.payroll_action_id
73: FROM pay_payroll_actions ppa,
74: hr_organization_information hoi
75: WHERE decode(hoi.org_information3,'Y',to_char(hoi.organization_id) ,hoi.org_information20) =
76: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
77: AND hoi.org_information_context='Prov Reporting Est'

Line 103: pay_payroll_actions ppa,

99: per_all_people_f ppf,
100: per_all_assignments_f paf,
101: pay_action_interlocks pai,
102: pay_assignment_actions paa,
103: pay_payroll_actions ppa,
104: pay_assignment_actions paa_arch
105: WHERE ppa.payroll_action_id =
106: to_number( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
107: AND paa.payroll_action_id = ppa.payroll_action_id

Line 238: pay_payroll_actions ppa1

234: hr_locations_all loc,
235: per_all_people_f ppf,
236: per_all_assignments_f paf,
237: pay_assignment_actions paa1,
238: pay_payroll_actions ppa1
239: where ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
240: and paa1.payroll_action_id = ppa1.payroll_action_id
241: and paa1.assignment_id = paf.assignment_id
242: and paf.assignment_type = 'E'