DBA Data[Home] [Help]

APPS.PA_SALESREPS dependencies on PA_PROJECTS

Line 25: pa_projects p,

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
29: AND c.project_id = pj_id

Line 47: pa_projects c,

43: I.sales_credit_type_code credit_type,
44: pt.cc_prvdr_flag ic_flag
45: FROM ra_salesreps a,
46: pa_project_players b,
47: pa_projects c,
48: pa_implementations I,
49: pa_project_types pt
50: WHERE c.project_id = b.project_id
51: AND b.project_id = pj_id