APPS.PA_PROJECT_PUB dependencies on PA_LOOKUPS

Line 45: from pa_lookups

41: /*new cursor for bug no 2413400*/
42: Cursor p_product_code_csr (p_pm_product_code IN VARCHAR2)
43: Is
44: Select 'X'
45: from pa_lookups
46: where lookup_type='PM_PRODUCT_CODE'
47: and lookup_code = p_pm_product_code;
48:
49: --FP.M Changes by rtarway for Mapping and Set Financial Task

Line 505: pa_lookups

501: CURSOR priority_code_csr(p_priority_code IN VARCHAR2) IS
502: Select
503: 'Y'
504: from
505: pa_lookups
506: where
507: lookup_type = 'PA_PROJECT_PRIORITY_CODE'
508: and lookup_code = p_priority_code ;
509:

Line 521: (SELECT NULL FROM pa_lookups

517: CURSOR cur_check_sec_level(p_proj_sec_level IN VARCHAR2 ) IS
518: SELECT 'Y' FROM
519: dual
520: WHERE EXISTS
521: (SELECT NULL FROM pa_lookups
522: WHERE
523: lookup_type = 'PA_PROJECT_ACCESS_LEVEL' AND
524: lookup_code = p_proj_sec_level
525: );

Line 7449: l_process_code pa_lookups.lookup_code%TYPE;

7445: l_update_wbs_flag VARCHAR2(1) ;
7446: l_structure_version_id NUMBER ;
7447:
7448: -- Bug 3010538
7449: l_process_code pa_lookups.lookup_code%TYPE;
7450:
7451: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
7452:
7453: -- Bug 3106457. Obtain the structure version id give the task version id.

Line 10380: pa_lookups

10376: CURSOR priority_code_csr(p_priority_code IN VARCHAR2) IS
10377: Select
10378: 'Y'
10379: from
10380: pa_lookups
10381: where
10382: lookup_type = 'PA_PROJECT_PRIORITY_CODE'
10383: and lookup_code = p_priority_code ;
10384:

Line 10396: (SELECT NULL FROM pa_lookups

10392: CURSOR cur_check_sec_level(p_proj_sec_level IN VARCHAR2 ) IS
10393: SELECT 'Y' FROM
10394: dual
10395: WHERE EXISTS
10396: (SELECT NULL FROM pa_lookups
10397: WHERE
10398: lookup_type = 'PA_PROJECT_ACCESS_LEVEL' AND
10399: lookup_code = p_proj_sec_level
10400: );

Line 29503: from pa_lookups

29499: /*cursor added for Bug 3651113 */
29500: Cursor p_product_code_csr (p_pm_product_code IN VARCHAR2)
29501: Is
29502: Select 'X'
29503: from pa_lookups
29504: where lookup_type='PM_PRODUCT_CODE'
29505: and lookup_code = p_pm_product_code;
29506:
29507: l_wp_task_flag varchar2(1); -- Added for bug5462298

Line 30647: from pa_lookups

30643: /*cursor added for Bug 3651113 */
30644: Cursor p_product_code_csr (p_pm_product_code IN VARCHAR2)
30645: Is
30646: Select 'X'
30647: from pa_lookups
30648: where lookup_type='PM_PRODUCT_CODE'
30649: and lookup_code = p_pm_product_code;
30650:
30651: Cursor C_vers (p_proj_element_id NUMBER) IS