APPS.PAY_CA_T4_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 28: pay_payroll_actions PPA,

24: 'SUBMISSION_REF_ID=P',ppa.payroll_action_id,
25: 'ORG_ID=P',hoi.organization_id,
26: 'T4_YEAR=P',to_char(ppa.effective_date,'YYYY')
27: FROM hr_organization_information hoi,
28: pay_payroll_actions PPA,
29: pay_ca_legislation_info pcli,
30: pay_ca_legislation_info pcli1,
31: pay_ca_legislation_info pcli2
32: WHERE hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')

Line 67: pay_payroll_actions ppa,

63: 'TAX_UNIT_NAME=P', fai.value,
64: 'TRANSFER_EI_ER_RATE=P', pcli2.information_value
65: From ff_archive_items fai,
66: ff_database_items fdi,
67: pay_payroll_actions ppa,
68: pay_assignment_actions AA,
69: pay_ca_legislation_info pcli2
70: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID') --Magtape Payroll Action id
71: and ppa.report_type = 'T4'

Line 103: pay_payroll_actions ppa,

99: From ff_archive_items fai,
100: ff_database_items fdi,
101: per_all_people_f ppf,
102: pay_assignment_actions paa,
103: pay_payroll_actions ppa,
104: pay_payroll_actions ppa_mag
105: where ppa_mag.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
106: and ppa.report_type = 'T4'
107: and ppa.report_qualifier = 'CAEOY'

Line 104: pay_payroll_actions ppa_mag

100: ff_database_items fdi,
101: per_all_people_f ppf,
102: pay_assignment_actions paa,
103: pay_payroll_actions ppa,
104: pay_payroll_actions ppa_mag
105: where ppa_mag.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
106: and ppa.report_type = 'T4'
107: and ppa.report_qualifier = 'CAEOY'
108: and ppa.report_category = 'CAEOY'