DBA Data[Home] [Help]

APPS.PAY_CA_T4_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 68: pay_assignment_actions AA,

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'
72: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

Line 102: pay_assignment_actions paa,

98: 'TRANSFER_JURISDICTION_CODE=P', fai.value
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'