APPS.PA_PLAN_RES_LIST_PUB dependencies on PA_LOOKUPS

Line 1961: FROM pa_lookups

1957: --End of bug 4103909.
1958:
1959: SELECT meaning || ' ' || to_char(i) || ':'
1960: INTO Pa_Planning_Resource_Pvt.g_token
1961: FROM pa_lookups
1962: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
1963: AND lookup_code = 'PLANNING_RESOURCE';
1964:
1965: L_one_pln_res_in_tbl(1) := L_planning_resource_in_tbl(i);

Line 2081: FROM pa_lookups

2077: --This means that the resource list member is already existing and is supposed to be updated.
2078:
2079: SELECT meaning || ' ' || to_char(i) || ':'
2080: INTO Pa_Planning_Resource_Pvt.g_token
2081: FROM pa_lookups
2082: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
2083: AND lookup_code = 'PLANNING_RESOURCE';
2084:
2085: -- Validate the record version number passed in.

Line 2318: FROM pa_lookups

2314: * This API would take care of deletion.
2315: ********************************************************/
2316: SELECT meaning || ' ' || to_char(i) || ':'
2317: INTO Pa_Planning_Resource_Pvt.g_token
2318: FROM pa_lookups
2319: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
2320: AND lookup_code = 'PLANNING_RESOURCE';
2321:
2322: Pa_Planning_Resource_Pvt.Delete_Planning_Resource(

Line 2738: FROM pa_lookups

2734: Loop
2735:
2736: SELECT meaning || ' ' || to_char(i) || ':'
2737: INTO Pa_Planning_Resource_Pvt.g_token
2738: FROM pa_lookups
2739: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
2740: AND lookup_code = 'PLANNING_RESOURCE';
2741:
2742: savepoint planning_resource_create;

Line 3438: FROM pa_lookups

3434:
3435: Begin
3436: SELECT meaning || ' ' || to_char(i) || ':'
3437: INTO Pa_Planning_Resource_Pvt.g_token
3438: FROM pa_lookups
3439: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
3440: AND lookup_code = 'PLANNING_RESOURCE';
3441:
3442:

Line 3648: FROM pa_lookups

3644: FOR i in 1..p_resource_list_member_id.COUNT
3645: LOOP
3646: SELECT meaning || ' ' || to_char(i) || ':'
3647: INTO Pa_Planning_Resource_Pvt.g_token
3648: FROM pa_lookups
3649: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
3650: AND lookup_code = 'PLANNING_RESOURCE';
3651:
3652: pa_planning_resource_pvt.delete_planning_resource