APPS.PAY_US_MWR_REPORTING_PKG dependencies on DUAL

Line 290: from dual;

286:
287: hr_utility.set_location(gv_package || '.action_creation', 50);
288: select pay_assignment_actions_s.nextval
289: into ln_locking_action_id
290: from dual;
291:
292: -- **** CHECK FOR SUI WAGES HERE **** ----
293:
294: -- insert into pay_assignment_actions.

Line 696: FROM dual;

692:
693: --get the session id
694: SELECT userenv('sessionid')
695: INTO v_session_id
696: FROM dual;
697:
698: --get the hierarchy version and establishment from legislative paramters
699: SELECT ppa.legislative_parameters
700: INTO l_ppa_legislative_parameters

Line 1003: FROM dual

999: IF (l_state_abbrev = 'MA') THEN
1000: BEGIN
1001: SELECT '1'
1002: INTO l_ma_resides_true
1003: FROM dual
1004: WHERE EXISTS (
1005: SELECT '1'
1006: FROM per_assignments_f paf,
1007: per_addresses pad