APPS.PAY_CA_T4_AMEND_MAG dependencies on PAY_CA_LEGISLATION_INFO

Line 17: pay_ca_legislation_info pcli,

13: to_char(max(ppa.payroll_action_id))
14: FROM
15: hr_organization_information hoi,
16: pay_payroll_actions ppa,
17: pay_ca_legislation_info pcli,
18: pay_ca_legislation_info pcli1,
19: pay_ca_legislation_info pcli2
20: WHERE hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')
21: AND hoi.org_information_context = 'Fed Magnetic Reporting'

Line 18: pay_ca_legislation_info pcli1,

14: FROM
15: hr_organization_information hoi,
16: pay_payroll_actions ppa,
17: pay_ca_legislation_info pcli,
18: pay_ca_legislation_info pcli1,
19: pay_ca_legislation_info pcli2
20: WHERE hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')
21: AND hoi.org_information_context = 'Fed Magnetic Reporting'
22: AND ppa.report_type = 'CAEOY_T4_AMEND_PP'

Line 19: pay_ca_legislation_info pcli2

15: hr_organization_information hoi,
16: pay_payroll_actions ppa,
17: pay_ca_legislation_info pcli,
18: pay_ca_legislation_info pcli1,
19: pay_ca_legislation_info pcli2
20: WHERE hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')
21: AND hoi.org_information_context = 'Fed Magnetic Reporting'
22: AND ppa.report_type = 'CAEOY_T4_AMEND_PP'
23: AND hoi.organization_id = pycadar_pkg.get_parameter('TRANSFER_GRE'

Line 51: pay_ca_legislation_info pcli2

47: pay_payroll_actions ppa,
48: pay_assignment_actions aa,
49: hr_organization_information hoi1,
50: hr_organization_information hoi2,
51: pay_ca_legislation_info pcli2
52: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
53: AND hoi1.org_information11 = aa.tax_unit_id
54: AND hoi1.org_information11 = hoi2.organization_id
55: AND hoi2.org_information_context = 'Fed Magnetic Reporting'