42: c.segment1 proj_num,
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