APPS.PA_GET_RESOURCE dependencies on PA_RESOURCE_LIST_MEMBERS

Line 35: pa_resource_list_members

31: SELECT
32: resource_list_member_id,
33: track_as_labor_flag
34: FROM
35: pa_resource_list_members
36: WHERE resource_list_id = p_resource_list_id
37: AND parent_member_id IS NULL
38: AND resource_id = l_resource_id;
39:

Line 186: 'Select resource_list_member_id from pa_resource_list_members';

182: RETURN;
183: END IF;
184:
185: p_err_stage :=
186: 'Select resource_list_member_id from pa_resource_list_members';
187: OPEN c_resource_list_member_csr;
188: FETCH c_resource_list_member_csr INTO
189: l_resource_list_member_id,
190: p_track_as_labor_flag;

Line 266: pa_resource_list_members

262: SELECT
263: resource_list_member_id,
264: track_as_labor_flag
265: FROM
266: pa_resource_list_members
267: WHERE resource_list_id = p_resource_list_id
268: AND parent_member_id IS NULL
269: AND resource_id = l_resource_id;
270:

Line 276: pa_resource_list_members

272: SELECT
273: resource_list_member_id,
274: track_as_labor_flag
275: FROM
276: pa_resource_list_members
277: WHERE resource_list_id = p_resource_list_id
278: AND parent_member_id = p_parent_member_id
279: AND resource_id = l_resource_id;
280: BEGIN

Line 337: 'Select resource_list_member_id from pa_resource_list_members';

333: RETURN;
334: END IF;
335:
336: p_err_stage :=
337: 'Select resource_list_member_id from pa_resource_list_members';
338: IF p_parent_member_id IS NULL THEN
339: OPEN c_resource_list_member_csr_1;
340: FETCH c_resource_list_member_csr_1 INTO
341: p_resource_list_member_id,

Line 879: pa_resource_list_members rlm

875: rlm.resource_id,
876: rlm.track_as_labor_flag
877: FROM
878: pa_resource_lists rl,
879: pa_resource_list_members rlm
880: WHERE rl.uncategorized_flag = 'Y'
881: AND rlm.resource_class_code = 'FINANCIAL_ELEMENTS' -- shelly
882: AND rlm.resource_class_flag = 'Y' --shelly
883: AND rl.resource_list_id = rlm.resource_list_id

Line 941: pa_resource_list_members

937: SELECT
938: resource_list_member_id,
939: track_as_labor_flag
940: FROM
941: pa_resource_list_members
942: WHERE resource_list_id = p_resource_list_id
943: AND parent_member_id IS NULL
944: AND resource_id = p_unclassified_resource_id;
945:

Line 951: pa_resource_list_members

947: SELECT
948: resource_list_member_id,
949: track_as_labor_flag
950: FROM
951: pa_resource_list_members
952: WHERE resource_list_id = p_resource_list_id
953: AND parent_member_id = p_parent_member_id
954: AND resource_id = p_unclassified_resource_id;
955:

Line 1106: exists ( select 1 from pa_resource_list_members p,pa_project_accum_headers h

1102: begin
1103: select 1
1104: into temp
1105: from sys.dual where
1106: exists ( select 1 from pa_resource_list_members p,pa_project_accum_headers h
1107: where p.resource_list_member_id = h.resource_list_member_id
1108: and p.parent_member_id = p_resource_id
1109: and h.project_id = p_project_id
1110: and h.task_id = p_task_id );

Line 1134: from pa_resource_list_members rlm

1130: SELECT 'x'
1131: FROM dual
1132: WHERE exists
1133: (select 'x'
1134: from pa_resource_list_members rlm
1135: , pa_resources r
1136: , pa_resource_types rt
1137: where
1138: rlm.resource_list_id = l_resource_list_id