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 5089: FROM pa_lookups

5085:
5086: CURSOR l_service_type_csr( p_service_type_code VARCHAR2 )
5087: IS
5088: SELECT 'x'
5089: FROM pa_lookups
5090: WHERE lookup_type = 'SERVICE TYPE'
5091: AND lookup_code = p_service_type_code;
5092:
5093: CURSOR l_task_rec_csr (l_project_id NUMBER ,l_task_id NUMBER)

Line 11052: FROM pa_lookups

11048:
11049: CURSOR get_lab_disc_reason_code_csr(p_labor_disc_reason_code VARCHAR2)
11050: IS
11051: SELECT 'x'
11052: FROM pa_lookups
11053: WHERE lookup_type ='RATE AND DISCOUNT REASON'
11054: AND lookup_code=p_labor_disc_reason_code
11055: AND trunc(nvl(end_date_active,sysdate)) >= trunc(sysdate);
11056:

Line 11060: FROM pa_lookups

11056:
11057: CURSOR get_nl_disc_reason_code_csr(p_non_labor_disc_reason_code VARCHAR2)
11058: IS
11059: SELECT 'x'
11060: FROM pa_lookups
11061: WHERE lookup_type ='RATE AND DISCOUNT REASON'
11062: AND lookup_code=p_non_labor_disc_reason_code
11063: AND trunc(nvl(end_date_active,sysdate)) >= trunc(sysdate);
11064: