APPS.PA_RBS_UTILS dependencies on PA_RBS_ELEMENT_MAP

Line 275: * Get the revenue Category Code from pa_rbs_element_map

271: END IF;
272:
273: IF p_resource_type_code = 'REVENUE_CATEGORY' THEN
274: /***********************************************
275: * Get the revenue Category Code from pa_rbs_element_map
276: * table, based on the ID passed.
277: ************************************************/
278: BEGIN
279: SELECT RESOURCE_NAME

Line 281: FROM Pa_rbs_element_map

277: ************************************************/
278: BEGIN
279: SELECT RESOURCE_NAME
280: INTO l_revenue_category_code
281: FROM Pa_rbs_element_map
282: --WHERE RESOURCE_NAME = 'REVENUE_CATEGORY' -- NEED TO REVISIT
283: WHERE resource_type_id =
284: (SELECT res_type_id
285: FROM pa_res_types_b

Line 404: FROM pa_rbs_element_map

400: IF p_resource_type_code IN ('NAMED_ROLE','USER_DEFINED') THEN
401: BEGIN
402: SELECT resource_name
403: INTO l_element_name
404: FROM pa_rbs_element_map
405: --WHERE RESOURCE_NAME = p_resource_type_code -- NEED TO REVISIT
406: WHERE resource_type_id =
407: (SELECT res_type_id
408: FROM pa_res_types_b

Line 663: pa_rbs_element_map c

659: pa_rbs_element_names_b a,
660: pa_rbs_elem_in_temp b,
661: fnd_lookup_values lk,
662: /* Changes for Bug 3780201 start*/
663: pa_rbs_element_map c
664: WHERE a.resource_source_id = b.resource_source_id
665: and a.resource_type_id = p_resource_type_id
666: and b.resource_type_id = p_resource_type_id
667: and lk.lookup_type = 'PA_PERSON_TYPE'

Line 820: Pa_rbs_element_map c,

816: FND_GLOBAL.LOGIN_ID
817: FROM
818: pa_rbs_element_names_b a,
819: pa_rbs_elem_in_temp b,
820: Pa_rbs_element_map c,
821: Fnd_Languages L
822: WHERE a.resource_source_id = b.resource_source_id
823: AND a.resource_type_id = p_resource_type_id
824: AND b.resource_type_id = p_resource_type_id

Line 860: Pa_rbs_element_map c,

856: FND_GLOBAL.LOGIN_ID
857: FROM
858: pa_rbs_element_names_b a,
859: pa_rbs_elem_in_temp b,
860: Pa_rbs_element_map c,
861: fnd_lookup_values lk
862: WHERE a.resource_source_id = b.resource_source_id
863: AND a.resource_type_id = p_resource_type_id
864: AND b.resource_type_id = p_resource_type_id

Line 2128: FROM pa_rbs_element_map map,-- For bug 3799582

2124: fnd_global.user_id,
2125: sysdate,
2126: fnd_global.user_id,
2127: fnd_global.login_id
2128: FROM pa_rbs_element_map map,-- For bug 3799582
2129: fnd_lookup_values lk,
2130: pa_rbs_element_names_b a
2131: WHERE map.resource_type_id = a.resource_type_id
2132: AND a.resource_source_id=map.resource_id

Line 2250: pa_rbs_element_map map

2246: fnd_global.user_id,
2247: fnd_global.login_id
2248: FROM fnd_lookup_values lk,
2249: pa_rbs_element_names_b a,
2250: pa_rbs_element_map map
2251: WHERE a.resource_source_id=map.resource_id
2252: AND map.resource_name=lk.lookup_code
2253: AND lk.Lookup_Type = 'REVENUE CATEGORY'
2254: AND a.resource_type_id=14);

Line 2367: FROM pa_rbs_element_map map,

2363: fnd_global.user_id,
2364: sysdate,
2365: fnd_global.user_id,
2366: fnd_global.login_id
2367: FROM pa_rbs_element_map map,
2368: pa_rbs_element_names_b a,
2369: Fnd_Languages L
2370: WHERE a.resource_type_id = 18
2371: AND a.resource_source_id = map.resource_id

Line 3076: FROM pa_rbs_element_map

3072: ELSIF l_list.group_res_type = 'REVENUE_CATEGORY' THEN
3073: BEGIN
3074: SELECT resource_id
3075: INTO l_revenue_category_id
3076: FROM pa_rbs_element_map
3077: WHERE resource_name = l_parents.revenue_category
3078: AND resource_type_id = (select res_type_id
3079: from pa_res_types_b
3080: where res_type_code = 'REVENUE_CATEGORY');

Line 3249: FROM pa_rbs_element_map

3245: IF l_members.revenue_category IS NOT NULL THEN
3246: BEGIN
3247: SELECT resource_id
3248: INTO l_revenue_category_id
3249: FROM pa_rbs_element_map
3250: WHERE resource_name = l_members.revenue_category
3251: AND resource_type_id = (select res_type_id
3252: from pa_res_types_b
3253: where res_type_code = 'REVENUE_CATEGORY');