[Home] [Help]
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
52: AND b.project_role_type = 'PROJECT MANAGER'
70: r.allow_sales_credit_flag
71: FROM
72: ra_interface_lines i,
73: pa_draft_invoices inv,
74: pa_implementations p,
75: ra_batch_sources r
76: WHERE
77: inv.project_id = pj_id
78: -- AND inv.draft_invoice_num = to_number(interface_line_attribute2) commented for bug 5330841
96: r.allow_sales_credit_flag
97: FROM
98: ra_interface_lines i,
99: pa_draft_invoices inv,
100: pa_implementations p,
101: ra_batch_sources r
102: WHERE
103: inv.project_id = pj_id
104: -- AND inv.draft_invoice_num = to_number(interface_line_attribute2)commented for bug 5330841
328: Cursor get_transfer_status
329: is
330: SELECT r.allow_sales_credit_flag
331: FROM ra_batch_sources r,
332: pa_implementations i
333: WHERE i.invoice_batch_source_id = r.batch_source_id;
334:
335: l_transfer varchar2(1);
336: l_dummy varchar2(1);
362: select 'x'
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
424: select 'x'
425: into l_dummy
426: from dual
427: where exists ( select 1
428: from pa_implementations i,
429: pa_lookups pa
430: where pa.lookup_type='CREDIT TYPE'
431: and i.sales_credit_type_code = pa.lookup_code
432: and pa.enabled_flag = 'Y'