DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on PAY_ASSIGNMENT_ACTIONS

Line 171: from pay_assignment_actions paa,

167: pay_ca_t4_reg.get_parameter('TYPE',ppa.legislative_parameters),
168: pay_ca_t4_reg.get_parameter('PRINT',ppa.legislative_parameters),
169: pay_ca_t4_reg.get_parameter('INSTRUCTIONS',ppa.legislative_parameters),
170: substr(paa.serial_number,1,2)
171: from pay_assignment_actions paa,
172: pay_payroll_actions ppa,
173: pay_assignment_actions paa1,
174: pay_payroll_actions ppa1
175: where ppa.payroll_action_id = paa.payroll_action_id

Line 173: pay_assignment_actions paa1,

169: pay_ca_t4_reg.get_parameter('INSTRUCTIONS',ppa.legislative_parameters),
170: substr(paa.serial_number,1,2)
171: from pay_assignment_actions paa,
172: pay_payroll_actions ppa,
173: pay_assignment_actions paa1,
174: pay_payroll_actions ppa1
175: where ppa.payroll_action_id = paa.payroll_action_id
176: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
177: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

Line 361: pay_assignment_actions paa

357:
358: cursor cur_gre_name is
359: select name
360: from hr_all_organization_units hou,
361: pay_assignment_actions paa
362: where paa.assignment_action_id = p_aa_id
363: and paa.tax_unit_id = hou.organization_id;
364:
365: begin