APPS.PAY_CA_YEPP_ADD_ACTIONS_PKG dependencies on DUAL

Line 366: select 1 from dual

362:
363: cursor c_t4_magtape_run_exists(cp_effective_date date,
364: cp_business_group_id number,
365: cp_gre_id number) is
366: select 1 from dual
367: where exists
368: (select 'X'
369: from hr_organization_information mag,
370: hr_organization_information gre,

Line 389: select 1 from dual

385:
386: cursor c_t4a_magtape_run_exists(cp_effective_date date,
387: cp_business_group_id number,
388: cp_gre_id number) is
389: select 1 from dual
390: where exists
391: (select 'X'
392: from hr_organization_information mag,
393: hr_organization_information gre,

Line 412: select 1 from dual

408:
409: cursor c_rl1_magtape_run_exists(cp_effective_date date,
410: cp_business_group_id number,
411: cp_pre_id number) is
412: select 1 from dual
413: where exists
414: (select 'X'
415: from hr_organization_information pre,
416: hr_all_organization_units hou,

Line 434: select 1 from dual

430:
431: cursor c_rl2_magtape_run_exists(cp_effective_date date,
432: cp_business_group_id number,
433: cp_pre_id number) is
434: select 1 from dual
435: where exists
436: (select 'X'
437: from hr_organization_information pre,
438: hr_all_organization_units hou,

Line 698: from dual;

694: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 100);
695:
696: select pay_assignment_actions_s.nextval
697: into lockingactid
698: from dual;
699:
700: hr_utility.trace('creating asg action');
701:
702: hr_nonrun_asact.insact(lockingactid => lockingactid,

Line 745: from dual;

741: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 130);
742:
743: select pay_assignment_actions_s.nextval
744: into lockingactid
745: from dual;
746:
747: hr_utility.trace('creating asg action');
748:
749: hr_nonrun_asact.insact(lockingactid => lockingactid,

Line 1005: from dual;

1001: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 100);
1002:
1003: select pay_assignment_actions_s.nextval
1004: into lockingactid
1005: from dual;
1006:
1007: hr_utility.trace('creating asg action');
1008:
1009: hr_nonrun_asact.insact(lockingactid => lockingactid,