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 2004: SELECT meaning FROM pa_lookups

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

Line 2232: SELECT meaning FROM pa_lookups

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

Line 2444: SELECT meaning FROM pa_lookups

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

Line 2733: SELECT meaning FROM pa_lookups

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