APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_LOOKUPS

Line 74: SELECT meaning FROM pa_lookups

70: WHERE version_id = p_version_id;
71:
72: CURSOR get_template_type
73: is
74: SELECT meaning FROM pa_lookups
75: WHERE lookup_type = 'PA_PAGE_TYPES'
76: AND lookup_code = 'PPR';
77:
78: l_type VARCHAR2(80); /* bug 2447763 */

Line 325: SELECT meaning FROM pa_lookups

321: WHERE version_id = p_version_id;
322:
323: CURSOR get_template_type
324: is
325: SELECT meaning FROM pa_lookups
326: WHERE lookup_type = 'PA_PAGE_TYPES'
327: AND lookup_code = 'PPR';
328:
329: l_type VARCHAR2(80); /* bug 2447763 */

Line 591: SELECT meaning FROM pa_lookups

587: WHERE version_id = p_version_id;
588:
589: CURSOR get_template_type
590: is
591: SELECT meaning FROM pa_lookups
592: WHERE lookup_type = 'PA_PAGE_TYPES'
593: AND lookup_code = 'PPR';
594:
595: l_type VARCHAR2(80); /* bug 2447763 */

Line 747: SELECT meaning FROM pa_lookups

743: AND report_status_code = 'PROGRESS_REPORT_PUBLISHED';
744:
745: CURSOR get_template_type
746: is
747: SELECT meaning FROM pa_lookups
748: WHERE lookup_type = 'PA_PAGE_TYPES'
749: AND lookup_code = 'PPR';
750:
751: l_type VARCHAR2(80); /* bug 2447763 */

Line 977: SELECT meaning FROM pa_lookups

973: AND report_status_code = 'PROGRESS_REPORT_SUBMITTED';
974:
975: CURSOR get_template_type
976: is
977: SELECT meaning FROM pa_lookups
978: WHERE lookup_type = 'PA_PAGE_TYPES'
979: AND lookup_code = 'PPR';
980:
981: l_type VARCHAR2(80); /* bug 2447763 */

Line 1126: SELECT meaning FROM pa_lookups

1122: AND report_status_code = 'PROGRESS_REPORT_SUBMITTED';
1123:
1124: CURSOR get_template_type
1125: is
1126: SELECT meaning FROM pa_lookups
1127: WHERE lookup_type = 'PA_PAGE_TYPES'
1128: AND lookup_code = 'PPR';
1129:
1130: l_type VARCHAR2(80); /* bug 2447763 */

Line 1294: SELECT meaning FROM pa_lookups

1290: AND active = '*';
1291:
1292: CURSOR get_template_type
1293: is
1294: SELECT meaning FROM pa_lookups
1295: WHERE lookup_type = 'PA_PAGE_TYPES'
1296: AND lookup_code = 'PPR';
1297:
1298: l_type VARCHAR2(80); /* bug 2447763 */

Line 2003: SELECT meaning FROM pa_lookups

1999:
2000:
2001: CURSOR get_template_type
2002: is
2003: SELECT meaning FROM pa_lookups
2004: WHERE lookup_type = 'PA_PAGE_TYPES'
2005: AND lookup_code = 'PPR';
2006:
2007:

Line 2231: SELECT meaning FROM pa_lookups

2227: AND pps.project_status_code = 'PROGRESS_REPORT_SUBMITTED');
2228:
2229: CURSOR get_template_type
2230: is
2231: SELECT meaning FROM pa_lookups
2232: WHERE lookup_type = 'PA_PAGE_TYPES'
2233: AND lookup_code = 'PPR';
2234:
2235: l_type VARCHAR2(80); /* bug 2447763 */

Line 2443: SELECT meaning FROM pa_lookups

2439: AND p2.object_type = p1.object_type;
2440:
2441: CURSOR get_template_type
2442: is
2443: SELECT meaning FROM pa_lookups
2444: WHERE lookup_type = 'PA_PAGE_TYPES'
2445: AND lookup_code = 'PPR';
2446:
2447: --Bug#3302984, added the function name parameter

Line 2732: SELECT meaning FROM pa_lookups

2728: l_dummy VARCHAR2(1);
2729:
2730: CURSOR get_template_type
2731: is
2732: SELECT meaning FROM pa_lookups
2733: WHERE lookup_type = 'PA_PAGE_TYPES'
2734: AND lookup_code = 'PPR';
2735:
2736: l_type VARCHAR2(80); /* bug 2447763 */