DBA Data[Home] [Help]

APPS.PA_RBS_MAPPING dependencies on PA_RBS_ELEMENT_MAP_S

Line 2862: pa_rbs_element_map src

2858: SET revenue_category_id =
2859: ( SELECT
2860: src.resource_id
2861: FROM
2862: pa_rbs_element_map src
2863: WHERE
2864: src.resource_name = dest.revenue_category_code AND
2865: src.resource_type_id = 14 )
2866: WHERE

Line 2874: pa_rbs_element_map src

2870: SET person_type_id =
2871: ( SELECT
2872: src.resource_id
2873: FROM
2874: pa_rbs_element_map src
2875: WHERE
2876: src.resource_name = dest.person_type_code AND
2877: src.resource_type_id = 11 )
2878: WHERE

Line 3259: SELECT PA_RBS_ELEMENT_MAP_S.nextval

3255: FROM PA_RBS_ELEMENT_MAP
3256: WHERE resource_name = l_resource_name
3257: AND resource_type_id = p_resource_type_id ;
3258: ELSIF l_count = 0 THEN
3259: SELECT PA_RBS_ELEMENT_MAP_S.nextval
3260: INTO x_resource_id
3261: FROM dual ;
3262:
3263: INSERT INTO PA_RBS_ELEMENT_MAP