DBA Data[Home] [Help]

APPS.PA_TASK_MANAGER dependencies on PA_PROJECT_ROLE_TYPES

Line 788: l_role_type pa_project_role_types.project_role_type%TYPE;

784: l_end_date_active DATE;
785: l_mgr_end_date_active DATE;
786: l_create_project_member VARCHAR2(1);
787: l_member_end_date_active DATE;
788: l_role_type pa_project_role_types.project_role_type%TYPE;
789: l_proj_counter NUMBER;
790:
791: l_msg_index_out NUMBER;
792:

Line 810: from pa_project_role_types

806: -- end if; /* Commented for the 2701884 */
807:
808: select project_role_type
809: into l_role_type
810: from pa_project_role_types
811: where project_role_id = p_project_role;
812:
813: /* This program should run only if the profile
814: 'PA: Task Managers restricted to Project Members' is set to yes. */