DBA Data[Home] [Help]

APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_RUN_TYPES_F

Line 184: ,pay_run_types_f prt

180: prt.shortname,
181: prt.run_type_id
182: from pay_action_interlocks intlk
183: ,pay_assignment_actions assact
184: ,pay_run_types_f prt
185: where intlk.locking_action_id = cp_run_action_id
186: and intlk.locked_action_id = assact.assignment_action_id
187: and assact.source_action_id is not null
188: and assact.run_type_id(+) = prt.run_type_id

Line 249: c_run_type pay_run_types_f.shortname%type;

245: l_assignment_id number;
246: l_asg_action_id number;
247: c_aaid number;
248: c_asg_id number;
249: c_run_type pay_run_types_f.shortname%type;
250: c_run_type_id number;
251: l_aaid number;
252: l_procedure varchar2(20) ;
253: