APPS.PA_PLAN_RES_LIST_PUB dependencies on PA_LOOKUPS

Line 1976: FROM pa_lookups

1972: --End of bug 4103909.
1973:
1974: SELECT meaning || ' ' || to_char(i) || ':'
1975: INTO Pa_Planning_Resource_Pvt.g_token
1976: FROM pa_lookups
1977: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
1978: AND lookup_code = 'PLANNING_RESOURCE';
1979:
1980: L_one_pln_res_in_tbl(1) := L_planning_resource_in_tbl(i);

Line 2096: FROM pa_lookups

2092: --This means that the resource list member is already existing and is supposed to be updated.
2093:
2094: SELECT meaning || ' ' || to_char(i) || ':'
2095: INTO Pa_Planning_Resource_Pvt.g_token
2096: FROM pa_lookups
2097: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
2098: AND lookup_code = 'PLANNING_RESOURCE';
2099:
2100: -- Validate the record version number passed in.

Line 2333: FROM pa_lookups

2329: * This API would take care of deletion.
2330: ********************************************************/
2331: SELECT meaning || ' ' || to_char(i) || ':'
2332: INTO Pa_Planning_Resource_Pvt.g_token
2333: FROM pa_lookups
2334: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
2335: AND lookup_code = 'PLANNING_RESOURCE';
2336:
2337: Pa_Planning_Resource_Pvt.Delete_Planning_Resource(

Line 2770: FROM pa_lookups

2766: Loop
2767:
2768: SELECT meaning || ' ' || to_char(i) || ':'
2769: INTO Pa_Planning_Resource_Pvt.g_token
2770: FROM pa_lookups
2771: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
2772: AND lookup_code = 'PLANNING_RESOURCE';
2773:
2774: savepoint planning_resource_create;

Line 3485: FROM pa_lookups

3481:
3482: Begin
3483: SELECT meaning || ' ' || to_char(i) || ':'
3484: INTO Pa_Planning_Resource_Pvt.g_token
3485: FROM pa_lookups
3486: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
3487: AND lookup_code = 'PLANNING_RESOURCE';
3488:
3489:

Line 3695: FROM pa_lookups

3691: FOR i in 1..p_resource_list_member_id.COUNT
3692: LOOP
3693: SELECT meaning || ' ' || to_char(i) || ':'
3694: INTO Pa_Planning_Resource_Pvt.g_token
3695: FROM pa_lookups
3696: WHERE lookup_type = 'PA_PLANNING_RESOURCE'
3697: AND lookup_code = 'PLANNING_RESOURCE';
3698:
3699: pa_planning_resource_pvt.delete_planning_resource