22: where pc.project_id = p.project_id
23: and pc.bill_another_project_flag='Y')) ip_flag /* Added for bug 6603869*/
24: FROM pa_credit_receivers c,
25: pa_projects p,
26: so_sales_credit_types sc,
27: pa_project_types pt
28: WHERE c.project_id = p.project_id
29: AND c.project_id = pj_id
30: AND c.transfer_to_ar_flag = 'Y'
363: into l_dummy
364: from dual
365: where exists ( select 1
366: from pa_implementations i,
367: so_sales_credit_types sc
368: where i.sales_credit_type_code = sc.name
369: and sc.enabled_flag = 'Y'
370: UNION ALL
371: select 1
390: INTO l_dummy
391: FROM sys.dual
392: WHERE exists ( select 'x'
393: from pa_credit_receivers c,
394: so_sales_credit_types sc
395: where c.project_id = pj_id
396: and c.credit_type_code = sc.name
397: and c.transfer_to_ar_flag = 'Y'
398: and sc.enabled_flag = 'Y' );