DBA Data[Home] [Help]

APPS.PAY_US_MWR_REPORTING_PKG dependencies on DUAL

Line 273: from dual;

269:
270: hr_utility.set_location(gv_package || '.action_creation', 50);
271: select pay_assignment_actions_s.nextval
272: into ln_locking_action_id
273: from dual;
274:
275: -- **** CHECK FOR SUI WAGES HERE **** ----
276:
277: -- insert into pay_assignment_actions.

Line 541: FROM dual;

537:
538: --get the session id
539: SELECT userenv('sessionid')
540: INTO v_session_id
541: FROM dual;
542:
543: --get the hierarchy version and establishment from legislative paramters
544: SELECT ppa.legislative_parameters
545: INTO l_ppa_legislative_parameters