APPS.PAY_CA_T4A_XML dependencies on PAY_ASSIGNMENT_ACTIONS

Line 62: from pay_assignment_actions

58: --commented by rgottipa for 10136689
59: /*
60: cursor transfer_block is
61: select 'TRANSFER_ACT_ID=P', assignment_action_id
62: from pay_assignment_actions
63: where payroll_action_id =
64: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
65: */
66:

Line 76: pay_assignment_actions paa1,

72: hr_all_organization_units hou1,
73: hr_locations_all loc,
74: per_all_people_f ppf,
75: per_all_assignments_f paf,
76: pay_assignment_actions paa1,
77: pay_payroll_actions ppa1
78: where paa1.payroll_action_id =
79: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
80: and paa1.payroll_action_id = ppa1.payroll_action_id

Line 123: from pay_assignment_actions

119:
120:
121: cursor assignment_block is
122: select 'TRANSFER_ACT_ID=P',pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
123: from pay_assignment_actions
124: where assignment_action_id=pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
125: and substr(serial_number,29,1)='N';
126:
127: level_cnt NUMBER :=0;