APPS.PA_PROJ_TEMPLATE_SETUP_UTILS dependencies on PA_LOOKUPS

Line 111: FROM pa_lookups

107:
108: CURSOR cur_customer_name
109: IS
110: SELECT meaning
111: FROM pa_lookups
112: WHERE lookup_type = 'CUSTOMER PROJECT RELATIONSHIP'
113: AND enabled_flag = 'Y'
114: AND trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate)
115: AND lookup_code = p_limiting_value;

Line 414: FROM pa_lookups

410: ) AS
411: CURSOR cur_field_name
412: IS
413: SELECT lookup_code
414: FROM pa_lookups
415: WHERE meaning = p_field_name_meaning
416: AND lookup_type = 'OVERRIDE FIELD';
417:
418: BEGIN

Line 468: FROM pa_lookups

464:
465: CURSOR cur_customer_name
466: IS
467: SELECT lookup_code
468: FROM pa_lookups
469: WHERE lookup_type = 'CUSTOMER PROJECT RELATIONSHIP'
470: AND enabled_flag = 'Y'
471: AND trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate)
472: AND meaning = p_specification;