DBA Data[Home] [Help]

APPS.PA_SALESREPS dependencies on RA_BATCH_SOURCES

Line 75: ra_batch_sources r

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
79: AND to_char(inv.draft_invoice_num) = trim(interface_line_attribute2) /* Added for bug 5330841 */

Line 101: ra_batch_sources r

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
105: AND to_char(inv.draft_invoice_num) = trim(interface_line_attribute2) /* Added for bug 5330841 */

Line 331: FROM ra_batch_sources r,

327: IS
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);