DBA Data[Home] [Help]

APPS.PAY_US_MARK_W2C_PAPER dependencies on DUAL

Line 482: select sysdate into lv_sysdate from dual;

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

Line 487: from dual;

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