APPS.PA_ALLOC_RUN dependencies on PA_EXPENDITURE_TYPES

Line 794: FROM pa_expenditure_types

790: AND ( pa_project_utils.check_project_action_allowed( p_project_id, 'NEW_TXNS') = 'Y')
791: AND (pa_project_stus_utils.is_project_closed( p_project_id )= 'N');
792: CURSOR C_exptype_exists(p_exp_type IN VARCHAR2) IS
793: SELECT 1
794: FROM pa_expenditure_types
795: WHERE expenditure_type = p_exp_type
796: AND TRUNC(G_sysdate) BETWEEN TRUNC(start_date_active)
797: AND TRUNC(nvl(end_date_active, G_sysdate));
798: CURSOR C_fixed_percent IS