APPS.PA_RBS_UTILS dependencies on PA_RBS_VERSIONS_TL

Line 64: FROM Pa_rbs_versions_tl

60: IF p_resource_type_code = 'VERSION' THEN
61: BEGIN
62: SELECT name
63: INTO l_element_name
64: FROM Pa_rbs_versions_tl
65: WHERE rbs_version_id = p_resource_source_id
66: AND language = userenv('LANG');
67: EXCEPTION
68: WHEN OTHERS THEN

Line 511: Pa_rbs_versions_tl c

507: FND_GLOBAL.LOGIN_ID
508: FROM
509: pa_rbs_element_names_b a,
510: pa_rbs_elem_in_temp b,
511: Pa_rbs_versions_tl c
512: WHERE a.resource_source_id = b.resource_source_id
513: AND a.resource_type_id = p_resource_type_id
514: AND b.resource_type_id = p_resource_type_id
515: AND c.rbs_version_id = a.resource_source_id

Line 1667: FROM pa_rbs_versions_tl vertl,

1663: fnd_global.user_id,
1664: sysdate,
1665: fnd_global.user_id,
1666: fnd_global.login_id
1667: FROM pa_rbs_versions_tl vertl,
1668: pa_rbs_element_names_b b
1669: WHERE b.resource_type_id = -1
1670: AND b.resource_source_id = vertl.rbs_version_id);
1671:

Line 2799: INSERT INTO PA_RBS_VERSIONS_TL(

2795:
2796: FOR l_names in get_lists_names(l_list.resource_list_id) LOOP -- RBS V TL Loop
2797: --dbms_output.put_line('Creating RBS Version Names TL');
2798: --dbms_output.put_line('RBS Version Name is: ' || l_names.name);
2799: INSERT INTO PA_RBS_VERSIONS_TL(
2800: RBS_VERSION_ID,
2801: NAME,
2802: DESCRIPTION,
2803: LANGUAGE,

Line 3645: INSERT INTO PA_RBS_VERSIONS_TL(

3641:
3642: FOR l_names in get_lists_names(l_list.resource_list_id) LOOP -- RBS V TL Loop
3643: --dbms_output.put_line('Creating RBS Version Names TL');
3644: --dbms_output.put_line('RBS Version Name is: ' || l_names.name);
3645: INSERT INTO PA_RBS_VERSIONS_TL(
3646: RBS_VERSION_ID,
3647: NAME,
3648: DESCRIPTION,
3649: LANGUAGE,