APPS.PAY_CA_RL1_AMEND_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 36: pay_payroll_actions PPA,

32: CURSOR mag_rl1_amend_transmitter IS
33: Select 'PAYROLL_ACTION_ID=P',MAX(ppa.payroll_action_id),
34: 'TRANSFER_CPP_MAX=P', pcli.information_value
35: FROM hr_organization_information hoi,
36: pay_payroll_actions PPA,
37: pay_ca_legislation_info pcli
38: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
39: and hoi.org_information_context='Prov Reporting Est'
40: and ppa.report_type ='CAEOY_RL1_AMEND_PP'

Line 63: from pay_payroll_actions ppa,

59: --
60: CURSOR mag_rl1_amend_employer IS
61: select distinct 'PAYROLL_ACTION_ID=C',MAX(ppa.payroll_action_id),
62: 'PAYROLL_ACTION_ID=P',MAX(ppa.payroll_action_id)
63: from pay_payroll_actions ppa,
64: hr_organization_information hoi
65: WHERE decode(hoi.org_information3,'Y',to_char(hoi.organization_id) ,hoi.org_information20) =
66: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
67: and hoi.org_information_context='Prov Reporting Est'

Line 94: pay_payroll_actions ppa,

90: per_all_people_f ppf,
91: per_all_assignments_f paf,
92: pay_action_interlocks pai,
93: pay_assignment_actions paa,
94: pay_payroll_actions ppa,
95: pay_assignment_actions paa_arch,
96: pay_payroll_actions ppa_arch
97: WHERE
98: ppa.payroll_action_id =

Line 96: pay_payroll_actions ppa_arch

92: pay_action_interlocks pai,
93: pay_assignment_actions paa,
94: pay_payroll_actions ppa,
95: pay_assignment_actions paa_arch,
96: pay_payroll_actions ppa_arch
97: WHERE
98: ppa.payroll_action_id =
99: to_number(pay_magtape_generic.get_parameter_value
100: ('TRANSFER_PAYROLL_ACTION_ID')) AND