DBA Data[Home] [Help]

APPS.PAY_US_MARK_W2C_PAPER dependencies on DUAL

Line 480: select sysdate into lv_sysdate from dual;

476: open get_paper_details (lp_assignment_action_id);
477: fetch get_paper_details into lv_creation_date;
478: close get_paper_details;
479:
480: select sysdate into lv_sysdate from dual;
481:
482:
483: select pay_assignment_actions_s.nextval
484: into ln_w2c_asg_action

Line 485: from dual;

481:
482:
483: select pay_assignment_actions_s.nextval
484: into ln_w2c_asg_action
485: from dual;
486: hr_utility.set_location(gv_package || '.action_creation', 20);
487: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));
488:
489: /* Insert into pay_assignment_actions. */