APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on DUAL

Line 66: FROM dual

62: BEGIN
63:
64: BEGIN
65: SELECT 'Y' into l_dummy
66: FROM dual
67: WHERE l_approver_id in
68: (SELECT pa_resource_utils.get_hr_manager_id(res_denorm.resource_id,l_start_date) approver_id
69: from pa_resources_denorm res_denorm
70: WHERE l_start_date between resource_effective_start_date

Line 86: from dual) prmry_contact_menu

82: fnd_objects fob,
83: per_all_people_f per,
84: wf_roles wfr,
85: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
86: from dual) prmry_contact_menu
87: where fob.obj_name = 'ORGANIZATION'
88: and res_denorm.resource_id = l_resource_id
89: and l_start_date between res_denorm.resource_effective_start_date and res_denorm.resource_effective_end_date
90: and fg.instance_pk1_value = to_char(res_denorm.resource_organization_id)

Line 108: from dual) res_auth_menu

104: fnd_objects fob,
105: wf_roles wfr,
106: per_people_f per,
107: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id
108: from dual) res_auth_menu
109: where fob.obj_name = 'ORGANIZATION'
110: and res_denorm.resource_id = l_resource_id
111: and fg.instance_pk1_value = to_char(res_denorm.resource_organization_id)
112: and l_start_date between res_denorm.resource_effective_start_date and res_denorm.resource_effective_end_date

Line 132: from dual) prmry_contact_menu,

128: fnd_grants fg2,
129: fnd_objects fob2,
130: wf_roles wfr2,
131: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
132: from dual) prmry_contact_menu,
133: per_people_f per2
134: where fob.obj_name = 'ORGANIZATION'
135: and fg2.instance_pk1_value = to_char(res_denorm.resource_organization_id)
136: and fg2.instance_type = 'INSTANCE'

Line 436: FROM dual

432: AND proj.project_id = c_project_id ;
433:
434: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS
435: SELECT 'Y'
436: FROM dual
437: WHERE EXISTS
438: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);
439:
440:

Line 2719: FROM dual

2715: AND proj.project_id = c_project_id ;
2716:
2717: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS
2718: SELECT 'Y'
2719: FROM dual
2720: WHERE EXISTS
2721: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);
2722:
2723: CURSOR c_get_subteam_party_id(c_requirement_id NUMBER) IS

Line 6254: FROM dual

6250: AND proj.project_id = c_project_id ;
6251:
6252: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS
6253: SELECT 'Y'
6254: FROM dual
6255: WHERE EXISTS
6256: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);
6257:
6258: CURSOR c_get_location(c_location_id NUMBER) IS

Line 8038: FROM dual

8034: AND proj.project_id = c_project_id ;
8035:
8036: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS
8037: SELECT 'Y'
8038: FROM dual
8039: WHERE EXISTS
8040: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);
8041:
8042: CURSOR c_derive_country_code(c_country_name IN VARCHAR2) IS