APPS.PA_PURGE_VALIDATE_BILLING dependencies on PA_PROJECTS

Line 58: pa_projects_all pp,

54: /* select 'Not Revenue Distributed' , 'PA_ARPR_NOT_REV_DIST'
55: from dual
56: where exists ( select spf.project_id
57: from pa_summary_project_fundings spf,
58: pa_projects_all pp,
59: -- pa_project_types_all pt -- performance changes bug 2706550
60: pa_project_types_v pt -- Added to remove FTS bug 2706550
61: where
62: pp.project_id = p_project_id

Line 143: from pa_projects_all pp

139: UNION
140: select 'UBR and UER not cleared' , 'PA_ARPR_NOT_UBR_UER'
141: from dual
142: where exists ( select project_id
143: from pa_projects_all pp
144: where pp.project_id = p_project_id
145: and
146: (nvl(pp.unbilled_receivable_dr,0) <> 0
147: or

Line 190: from pa_projects pp, pa_project_types pt

186: UNION
187: select 'This is an Inter Company Billing Project', 'PA_ARPR_IC_BILLING_PROJ'
188: from dual
189: where exists ( select null
190: from pa_projects pp, pa_project_types pt
191: where pp.project_id = p_project_id
192: and pp.project_type = pt.project_type
193: and pt.project_type_class_code = 'CONTRACT'
194: and pt.cc_prvdr_flag = 'Y'