APPS.GMS_BUDGET_CORE dependencies on PA_RESOURCE_LIST_MEMBERS

Line 1970: FROM pa_resource_list_members prl

1966: INTO dummy
1967: FROM DUAL
1968: WHERE EXISTS (
1969: SELECT 1
1970: FROM pa_resource_list_members prl
1971: WHERE prl.resource_list_member_id = x_rlmid
1972: AND prl.parent_member_id IS NULL );
1973: exception
1974: when NO_DATA_FOUND then

Line 2309: pa_resource_list_members m,

2305: into x_uncat_res_list_member_id,
2306: x_uncat_track_as_labor_flag,
2307: x_uncat_unit_of_measure
2308: from pa_resources r,
2309: pa_resource_list_members m,
2310: --gms_implementations gia, -- Commented out NOCOPY for Bug:2113499
2311: pa_implementations pi,
2312: pa_resource_lists l
2313: where l.uncategorized_flag = 'Y'

Line 2502: from pa_resource_list_members m

2498: -- project level, categorized
2499: for res_rec in (select m.resource_list_member_id,
2500: m.resource_id,
2501: m.track_as_labor_flag
2502: from pa_resource_list_members m
2503: where m.resource_list_id = x_resource_list_id
2504: and not exists
2505: (select 1
2506: from pa_resource_list_members m1

Line 2506: from pa_resource_list_members m1

2502: from pa_resource_list_members m
2503: where m.resource_list_id = x_resource_list_id
2504: and not exists
2505: (select 1
2506: from pa_resource_list_members m1
2507: where m1.parent_member_id =
2508: m.resource_list_member_id
2509: AND NVL(m1.migration_code,'M') ='M') -- Bug 3626671
2510: and exists (select 1 -- Bug 1831151

Line 2676: from pa_resource_list_members m

2672: -- top level task, categorized
2673: for res_rec in (select m.resource_list_member_id,
2674: m.resource_id,
2675: m.track_as_labor_flag
2676: from pa_resource_list_members m
2677: where m.resource_list_id =
2678: x_resource_list_id
2679: and not exists
2680: (select 1

Line 2681: from pa_resource_list_members m1

2677: where m.resource_list_id =
2678: x_resource_list_id
2679: and not exists
2680: (select 1
2681: from pa_resource_list_members m1
2682: where m1.parent_member_id =
2683: m.resource_list_member_id
2684: AND NVL(m1.migration_code,'M') ='M') -- Bug 3626671
2685: AND EXISTS ( SELECT 1-- added for bug 1831151

Line 2841: from pa_resource_list_members m

2837: -- lowest level task, categorized
2838: for res_rec in (select m.resource_list_member_id,
2839: m.resource_id,
2840: m.track_as_labor_flag
2841: from pa_resource_list_members m
2842: where m.resource_list_id =
2843: x_resource_list_id
2844: and not exists
2845: (select 1

Line 2846: from pa_resource_list_members m1

2842: where m.resource_list_id =
2843: x_resource_list_id
2844: and not exists
2845: (select 1
2846: from pa_resource_list_members m1
2847: where m1.parent_member_id =
2848: m.resource_list_member_id
2849: AND NVL(m1.migration_code,'M') ='M') -- Bug 3626671
2850: AND EXISTS ( SELECT 1 -- Bug 1831151