DBA Data[Home] [Help]

APPS.PA_PROJ_TEMPLATE_SETUP_UTILS dependencies on PA_PROJECT_ROLE_TYPES_VL

Line 104: FROM pa_project_role_types_vl roles

100: IS
101: CURSOR cur_key_member
102: IS
103: SELECT roles.meaning
104: FROM pa_project_role_types_vl roles
105: WHERE trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate)
106: AND roles.project_role_type = p_limiting_value;
107:
108: CURSOR cur_customer_name

Line 461: FROM pa_project_role_types_vl roles

457:
458: CURSOR cur_key_member
459: IS
460: SELECT roles.project_role_type
461: FROM pa_project_role_types_vl roles
462: WHERE trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate)
463: AND roles.meaning = p_specification;
464:
465: CURSOR cur_customer_name