APPS.PA_BILLING_PROCESS_PKG dependencies on PA_PROJECT_UTILS

Line 33: AND pa_project_utils.check_prj_stus_action_allowed(p.project_status_code,'GENERATE_REV') = 'Y'; /* Added for bug 8887579*/

29: OR project_id =pproject_id)
30: AND p.project_type = t.project_type
31: AND t.project_type_class_code = 'CONTRACT'
32: AND t.direct_flag = 'Y' /*Added for bug 9359035*/
33: AND pa_project_utils.check_prj_stus_action_allowed(p.project_status_code,'GENERATE_REV') = 'Y'; /* Added for bug 8887579*/
34: /*
35: CURSOR ctask(cproject_id VARCHAR2) is
36: SELECT *
37: FROM pa_tasks a

Line 81: ' AND pa_project_utils.check_prj_stus_action_allowed(p.project_status_code,''GENERATE_REV'') = ''Y'' ';

77: ' OR project_id = :pprj_id)'||
78: ' AND p.project_type = t.project_type '||
79: ' AND t.project_type_class_code = ''CONTRACT'' '||
80: ' AND t.direct_flag = ''Y'' '||
81: ' AND pa_project_utils.check_prj_stus_action_allowed(p.project_status_code,''GENERATE_REV'') = ''Y'' ';
82:
83: IF G_ProjectType_ID <> 0 THEN
84: v_inv_query2 := 'AND t.project_type_id = '|| G_ProjectType_ID;
85: v_inv_query1 := v_inv_query1 || v_inv_query2;