APPS.PA_RBS_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 2510: FROM pa_resource_list_members

2506: SELECT resource_list_member_id,
2507: organization_id,
2508: expenditure_category,
2509: revenue_category
2510: FROM pa_resource_list_members
2511: WHERE resource_list_id = p_resource_list_id
2512: AND migration_code = 'M'
2513: AND resource_type_id not in (110, 107)
2514: AND parent_member_id is null;

Line 2529: FROM pa_resource_list_members child

2525: child.event_type,
2526: child.expenditure_type,
2527: child.expenditure_category,
2528: child.revenue_category
2529: FROM pa_resource_list_members child
2530: WHERE child.resource_list_id = p_resource_list_id
2531: AND ((child.parent_member_id IS NOT NULL AND
2532: EXISTS (SELECT 'Y' FROM pa_resource_lists_all_bg
2533: WHERE resource_list_id = p_resource_list_id

Line 2560: FROM pa_resource_list_members rlm,

2556:
2557: CURSOR get_rev_cat(p_resource_list_id NUMBER) IS
2558: SELECT rlm.revenue_category,
2559: typ.res_type_id -- resource_type_id
2560: FROM pa_resource_list_members rlm,
2561: (select res_type_id from pa_res_types_b
2562: where res_type_code = 'REVENUE_CATEGORY') typ
2563: WHERE rlm.resource_list_id = p_resource_list_id
2564: AND rlm.resource_type_id = 109;

Line 2854: FROM pa_resource_list_members rlm,

2850: decode(typ.res_type_code, 'SUPPLIER', rlm.vendor_id,
2851: decode(typ.res_type_code, 'ROLE', rlm.project_role_id,
2852: NULL))))), -- resource_source_id,
2853: typ.res_type_id -- resource_type_id
2854: FROM pa_resource_list_members rlm,
2855: (select res_type_id, res_type_code from pa_res_types_b) typ
2856: WHERE rlm.resource_list_id = l_list.resource_list_id
2857: AND ((rlm.resource_type_id = 103
2858: AND typ.res_type_code = 'ORGANIZATION') OR -- Org

Line 2874: FROM pa_resource_list_members rlm,

2870: (resource_source_id,
2871: resource_type_id)
2872: SELECT source.resource_source_id,
2873: typ.res_type_id -- resource_type_id
2874: FROM pa_resource_list_members rlm,
2875: (select res_type_id, res_type_code from pa_res_types_b) typ,
2876: ((select expenditure_type_id resource_source_id,
2877: expenditure_type resource_name, 1 type_number
2878: from pa_expenditure_types)

Line 2912: pa_resource_list_members rlm,

2908: (
2909: (SELECT source.resource_source_id,
2910: typ.res_type_id -- resource_type_id
2911: FROM
2912: pa_resource_list_members rlm,
2913: (select res_type_id, res_type_code from pa_res_types_b) typ,
2914: ((select expenditure_category_id resource_source_id,
2915: expenditure_category resource_name, 2 type_number
2916: from pa_expenditure_categories)

Line 2936: pa_resource_list_members rlm,

2932: UNION ALL
2933: (SELECT source.resource_source_id,
2934: typ.res_type_id -- resource_type_id
2935: FROM
2936: pa_resource_list_members rlm,
2937: (select res_type_id, res_type_code from pa_res_types_b) typ,
2938: (select expenditure_type_id resource_source_id,
2939: expenditure_type resource_name, 1 type_number
2940: from pa_expenditure_types) source

Line 3158: -- Stamp rbs element ID on pa_resource_list_members for

3154: sysdate,
3155: fnd_global.user_id,
3156: fnd_global.login_id,
3157: 1);
3158: -- Stamp rbs element ID on pa_resource_list_members for
3159: -- parent
3160:
3161: -- IF l_status = 'FROZEN' THEN
3162: UPDATE pa_resource_list_members

Line 3162: UPDATE pa_resource_list_members

3158: -- Stamp rbs element ID on pa_resource_list_members for
3159: -- parent
3160:
3161: -- IF l_status = 'FROZEN' THEN
3162: UPDATE pa_resource_list_members
3163: SET migrated_rbs_element_id = l_rbs_element_id
3164: WHERE resource_list_member_id =
3165: l_parents.resource_list_member_id;
3166: -- END IF;

Line 3205: FROM pa_resource_list_members

3201: IF l_members.parent_member_id IS NOT NULL THEN
3202: -- BEGIN
3203: SELECT migrated_rbs_element_id
3204: INTO l_parent_element_id
3205: FROM pa_resource_list_members
3206: WHERE resource_list_member_id =
3207: l_members.parent_member_id;
3208: -- EXCEPTION WHEN NO_DATA_FOUND THEN
3209: -- rollback to l_resource_list_savepoint;

Line 3370: -- Stamp rbs element ID on pa_resource_list_members for

3366: fnd_global.user_id,
3367: fnd_global.login_id,
3368: 1);
3369:
3370: -- Stamp rbs element ID on pa_resource_list_members for
3371: -- parent
3372:
3373: -- IF l_status = 'FROZEN' THEN
3374: UPDATE pa_resource_list_members

Line 3374: UPDATE pa_resource_list_members

3370: -- Stamp rbs element ID on pa_resource_list_members for
3371: -- parent
3372:
3373: -- IF l_status = 'FROZEN' THEN
3374: UPDATE pa_resource_list_members
3375: SET migrated_rbs_element_id = l_rbs_element_id
3376: WHERE resource_list_member_id =
3377: l_members.resource_list_member_id;
3378: -- END IF;