APPS.PA_ALLOC_RUN dependencies on PA_EXPENDITURE_TYPES

Line 786: FROM pa_expenditure_types

782: AND ( pa_project_utils.check_project_action_allowed( p_project_id, 'NEW_TXNS') = 'Y')
783: AND (pa_project_stus_utils.is_project_closed( p_project_id )= 'N');
784: CURSOR C_exptype_exists(p_exp_type IN VARCHAR2) IS
785: SELECT 1
786: FROM pa_expenditure_types
787: WHERE expenditure_type = p_exp_type
788: AND TRUNC(G_sysdate) BETWEEN TRUNC(start_date_active)
789: AND TRUNC(nvl(end_date_active, G_sysdate));
790: CURSOR C_fixed_percent IS