APPS.PAY_US_MMREF_LOCAL_XML dependencies on DUAL

Line 570: FROM dual;

566: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
567: IF (l_report_type = 'W2_MAG_XML') then
568: SELECT pay_assignment_actions_s.nextval
569: INTO lockingactid
570: FROM dual;
571: hr_utility.set_location(
572: 'pay_us_mmref_local_xml.create_assignement_act', 60);
573: hr_nonrun_asact.insact( lockingactid,
574: l_assignment_id,

Line 949: select 'Y' from dual

945: select person_id from per_all_assignments_f
946: where assignment_id = p_assignment_id ;
947:
948: cursor c_get_non_pa_emp_det( p_person_id in number ) is
949: select 'Y' from dual
950: where not exists
951: ( select person_id from per_addresses
952: where person_id = p_person_id
953: and region_2 = 'PA'