DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_ARCHIVE_PKG dependencies on DUAL

Line 266: from dual;

262: hr_utility.set_location('LUMP SUM:' || to_char(asgrec.assignment_id),10);
263:
264: select pay_assignment_actions_s.nextval
265: into lockingactid
266: from dual;
267: hr_utility.set_location('lockingactidM:' || lockingactid,10);
268: -- Insert Lump Sums into pay_assignment_actions
269: hr_nonrun_asact.insact
270: (

Line 284: from dual;

280: -- For Normal
281:
282: select pay_assignment_actions_s.nextval
283: into lockingactid
284: from dual;
285:
286: -- Insert assignment into pay_assignment_actions
287: hr_nonrun_asact.insact
288: (

Line 365: FROM dual;

361: and ppa.action_type in ('R', 'Q','V', 'B', 'I') -- added for 5165859
362: )
363: UNION
364: Select '99999999999'
365: FROM dual;
366:
367: -- Cursor for Directive Number Context
368: /*CURSOR curdirnum (p_assignment_action_id IN number) is
369: Select max(context_value) directive_number