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 2720: FROM dual

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

Line 6255: FROM dual

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

Line 8040: FROM dual

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