DBA Data[Home] [Help]

APPS.PAY_CA_RL2_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 98: pay_assignment_actions paa,

94: FROM pay_action_information pin,
95: per_all_people_f ppf,
96: per_all_assignments_f paf,
97: pay_action_interlocks pai,
98: pay_assignment_actions paa,
99: pay_payroll_actions ppa,
100: pay_assignment_actions paa_arch
101: WHERE ppa.payroll_action_id =
102: to_number( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))

Line 100: pay_assignment_actions paa_arch

96: per_all_assignments_f paf,
97: pay_action_interlocks pai,
98: pay_assignment_actions paa,
99: pay_payroll_actions ppa,
100: pay_assignment_actions paa_arch
101: WHERE ppa.payroll_action_id =
102: to_number( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
103: AND paa.payroll_action_id = ppa.payroll_action_id
104: AND pai.locking_action_id = paa.assignment_action_id

Line 195: from pay_assignment_actions

191: from sys.dual;
192:
193: cursor transfer_block is
194: select 'TRANSFER_ACT_ID=P', assignment_action_id
195: from pay_assignment_actions
196: where payroll_action_id =
197: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
198:
199: FUNCTION convert_special_char( p_data IN VARCHAR2)