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 506: pa_lookups

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

Line 519: from pa_lookups

515:
516: Cursor c_adj_on_std_inv (p_adj_on_std_inv IN VARCHAR2)
517: Is
518: Select 'X'
519: from pa_lookups
520: where lookup_type='PA_ADJ_ON_STD_INV'
521: and lookup_code = p_adj_on_std_inv;
522:
523: /* Added for 12.2Payroll billing ER 11899223 */

Line 533: (SELECT NULL FROM pa_lookups

529: CURSOR cur_check_sec_level(p_proj_sec_level IN VARCHAR2 ) IS
530: SELECT 'Y' FROM
531: dual
532: WHERE EXISTS
533: (SELECT NULL FROM pa_lookups
534: WHERE
535: lookup_type = 'PA_PROJECT_ACCESS_LEVEL' AND
536: lookup_code = p_proj_sec_level
537: );

Line 5887: from pa_lookups

5883:
5884: Cursor c_adj_on_std_inv (p_adj_on_std_inv IN VARCHAR2)
5885: Is
5886: Select 'X'
5887: from pa_lookups
5888: where lookup_type='PA_ADJ_ON_STD_INV'
5889: and lookup_code = p_adj_on_std_inv;
5890:
5891:

Line 5981: * 2. Do not validate p_pm_product_code if its null or 'WORKPLAN' against pa_lookups

5977: /*
5978: * Bug 9379239
5979: * As per bug 2841158, the following validations are done for pm_product_code
5980: * 1. Throw PA_PRODUCT_CODE_IS_MISSING only if p_pm_product_code is g_miss_char
5981: * 2. Do not validate p_pm_product_code if its null or 'WORKPLAN' against pa_lookups
5982: */
5983: IF (p_pm_product_code IS NOT NULL) AND (p_pm_product_code <> 'WORKPLAN') THEN
5984:
5985: l_pm_product_code := 'Z'; -- Reset global variable l_pm_product_code

Line 7693: l_process_code pa_lookups.lookup_code%TYPE;

7689: l_update_wbs_flag VARCHAR2(1) ;
7690: l_structure_version_id NUMBER ;
7691:
7692: -- Bug 3010538
7693: l_process_code pa_lookups.lookup_code%TYPE;
7694:
7695: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
7696:
7697: -- Bug 3106457. Obtain the structure version id give the task version id.

Line 10134: from pa_lookups

10130:
10131: Cursor c_adj_on_std_inv (p_adj_on_std_inv IN VARCHAR2)
10132: Is
10133: Select 'X'
10134: from pa_lookups
10135: where lookup_type='PA_ADJ_ON_STD_INV'
10136: and lookup_code = p_adj_on_std_inv;
10137: proj_adj_on_std_inv varchar2(1) :='N';
10138: t_adj_on_std_inv varchar2(2);

Line 10642: pa_lookups

10638: CURSOR priority_code_csr(p_priority_code IN VARCHAR2) IS
10639: Select
10640: 'Y'
10641: from
10642: pa_lookups
10643: where
10644: lookup_type = 'PA_PROJECT_PRIORITY_CODE'
10645: and lookup_code = p_priority_code ;
10646:

Line 10658: (SELECT NULL FROM pa_lookups

10654: CURSOR cur_check_sec_level(p_proj_sec_level IN VARCHAR2 ) IS
10655: SELECT 'Y' FROM
10656: dual
10657: WHERE EXISTS
10658: (SELECT NULL FROM pa_lookups
10659: WHERE
10660: lookup_type = 'PA_PROJECT_ACCESS_LEVEL' AND
10661: lookup_code = p_proj_sec_level
10662: );

Line 22833: from pa_lookups

22829:
22830: Cursor c_adj_on_std_inv (p_adj_on_std_inv IN VARCHAR2)
22831: Is
22832: Select 'X'
22833: from pa_lookups
22834: where lookup_type='PA_ADJ_ON_STD_INV'
22835: and lookup_code = p_adj_on_std_inv;
22836:
22837: l_proj_top_task_customer_flag VARCHAR2(1);

Line 30128: from pa_lookups

30124: /*cursor added for Bug 3651113 */
30125: Cursor p_product_code_csr (p_pm_product_code IN VARCHAR2)
30126: Is
30127: Select 'X'
30128: from pa_lookups
30129: where lookup_type='PM_PRODUCT_CODE'
30130: and lookup_code = p_pm_product_code;
30131:
30132: l_wp_task_flag varchar2(1); -- Added for bug5462298

Line 31272: from pa_lookups

31268: /*cursor added for Bug 3651113 */
31269: Cursor p_product_code_csr (p_pm_product_code IN VARCHAR2)
31270: Is
31271: Select 'X'
31272: from pa_lookups
31273: where lookup_type='PM_PRODUCT_CODE'
31274: and lookup_code = p_pm_product_code;
31275:
31276: Cursor C_vers (p_proj_element_id NUMBER) IS