APPS.PA_SALESREPS dependencies on PA_CREDIT_RECEIVERS

Line 24: FROM pa_credit_receivers c,

20: pt.cc_prvdr_flag ic_flag,
21: (select 'Y' from dual where exists (select 1 from pa_project_customers pc
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

Line 372: from pa_credit_receivers

368: where i.sales_credit_type_code = sc.name
369: and sc.enabled_flag = 'Y'
370: UNION ALL
371: select 1
372: from pa_credit_receivers
373: WHERE project_id = pj_id
374: AND transfer_to_ar_flag = 'Y'
375: AND ROWNUM = 1 );
376:

Line 382: FROM pa_credit_receivers

378: l_step := 10;
379:
380: SELECT 'x'
381: INTO l_dummy
382: FROM pa_credit_receivers
383: WHERE project_id = pj_id
384: AND transfer_to_ar_flag = 'Y'
385: AND ROWNUM = 1 ;
386:

Line 393: from pa_credit_receivers c,

389: SELECT 'x'
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'

Line 406: from pa_Credit_receivers

402: select 'x'
403: into l_dummy
404: from dual
405: where exists ( select 1
406: from pa_Credit_receivers
407: where project_id = pj_id
408: AND transfer_to_Ar_flag = 'Y'
409: AND sysdate between start_date_Active and end_date_Active
410: ); */

Line 435: from pa_credit_receivers

431: and i.sales_credit_type_code = pa.lookup_code
432: and pa.enabled_flag = 'Y'
433: UNION ALL
434: select 1
435: from pa_credit_receivers
436: WHERE project_id = pj_id
437: AND transfer_to_ar_flag = 'Y'
438: AND ROWNUM = 1 );
439:

Line 444: FROM pa_credit_receivers

440: l_step := 10;
441:
442: SELECT 'x'
443: INTO l_dummy
444: FROM pa_credit_receivers
445: WHERE project_id = pj_id
446: AND transfer_to_ar_flag = 'Y'
447: AND ROWNUM = 1 ;
448:

Line 455: from pa_credit_receivers c,

451: SELECT 'x'
452: INTO l_dummy
453: FROM sys.dual
454: WHERE exists ( select 'x'
455: from pa_credit_receivers c,
456: pa_lookups pa
457: where c.project_id = pj_id
458: and pa.lookup_type='CREDIT TYPE'
459: and c.credit_type_code = pa.lookup_code

Line 470: from pa_Credit_receivers

466: select 'x'
467: into l_dummy
468: from dual
469: where exists ( select 1
470: from pa_Credit_receivers
471: where project_id = pj_id
472: AND transfer_to_Ar_flag = 'Y'
473: AND sysdate between start_date_active and end_date_Active
474: ); */