APPS.PA_SALESREPS dependencies on SO_SALES_CREDIT_TYPES

Line 26: so_sales_credit_types sc,

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'

Line 367: so_sales_credit_types sc

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

Line 394: so_sales_credit_types sc

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' );