DBA Data[Home] [Help]

APPS.PA_SALESREPS dependencies on PA_PROJECT_TYPES

Line 27: pa_project_types pt

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'
31: AND c.credit_type_code = sc.name

Line 49: pa_project_types pt

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
52: AND b.project_role_type = 'PROJECT MANAGER'
53: AND b.person_id = a.person_id