DBA Data[Home] [Help]

APPS.PAY_CA_T4A_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 90: pay_assignment_actions AA

86: 'TRANSFER_TAX_UNIT_ID=P', to_char(AA.tax_unit_id)
87: From ff_archive_items fai,
88: ff_database_items fdi,
89: pay_payroll_actions ppa,
90: pay_assignment_actions AA
91: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID') --Magtape Payroll Action id
92: and ppa.report_type = 'T4A'
93: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
94: and to_char(ppa.effective_date,'DD-MM') = '31-12'

Line 119: pay_assignment_actions paa,

115: From
116: per_all_people_f ppf,
117: per_all_assignments_f paf,
118: pay_action_interlocks pai,
119: pay_assignment_actions paa,
120: pay_payroll_actions ppa
121: Where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
122: AND paa.payroll_action_id = ppa.payroll_action_id
123: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')