APPS.PA_PROJECT_PVT dependencies on PA_LOOKUPS

Line 26: from pa_lookups

22: /*code added for bug no:2413400 */
23: Cursor p_product_code_csr (p_pm_product_code IN VARCHAR2)
24: Is
25: Select 'X'
26: from pa_lookups
27: where lookup_type='PM_PRODUCT_CODE'
28: and lookup_code = p_pm_product_code;
29:
30:

Line 1047: FROM pa_lookups

1043:
1044: CURSOR l_service_type_csr( p_service_type_code VARCHAR2 )
1045: IS
1046: SELECT 'x'
1047: FROM pa_lookups
1048: WHERE lookup_type = 'SERVICE TYPE'
1049: AND lookup_code = p_service_type_code;
1050:
1051: l_api_name CONSTANT VARCHAR2(30) := 'add_task_round_one';

Line 5287: FROM pa_lookups

5283:
5284: CURSOR l_service_type_csr( p_service_type_code VARCHAR2 )
5285: IS
5286: SELECT 'x'
5287: FROM pa_lookups
5288: WHERE lookup_type = 'SERVICE TYPE'
5289: AND lookup_code = p_service_type_code;
5290:
5291: CURSOR l_task_rec_csr (l_project_id NUMBER ,l_task_id NUMBER)

Line 11402: FROM pa_lookups

11398:
11399: CURSOR get_lab_disc_reason_code_csr(p_labor_disc_reason_code VARCHAR2)
11400: IS
11401: SELECT 'x'
11402: FROM pa_lookups
11403: WHERE lookup_type ='RATE AND DISCOUNT REASON'
11404: AND lookup_code=p_labor_disc_reason_code
11405: AND trunc(nvl(end_date_active,sysdate)) >= trunc(sysdate);
11406:

Line 11410: FROM pa_lookups

11406:
11407: CURSOR get_nl_disc_reason_code_csr(p_non_labor_disc_reason_code VARCHAR2)
11408: IS
11409: SELECT 'x'
11410: FROM pa_lookups
11411: WHERE lookup_type ='RATE AND DISCOUNT REASON'
11412: AND lookup_code=p_non_labor_disc_reason_code
11413: AND trunc(nvl(end_date_active,sysdate)) >= trunc(sysdate);
11414: