APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on PA_IMPLEMENTATIONS

Line 111: pa_implementations pa

107: FROM ra_customer_trx_lines_all ctl,
108: ra_customer_trx_all ct,
109: ra_terms_lines tl,
110: ra_cust_trx_types_all ctt,
111: pa_implementations pa
112: WHERE ctl.request_id = p_request_id
113: AND ctl.customer_trx_id = ct.customer_trx_id
114: AND ct.batch_source_id NOT IN (20, 21)
115: AND ct.org_id = pa.org_id (+)

Line 181: pa_implementations pa

177: FROM ra_customer_trx_lines_all ctl,
178: ra_customer_trx_all ct,
179: ra_terms_lines tl,
180: ra_cust_trx_types_all ctt,
181: pa_implementations pa
182: WHERE ctl.request_id = p_request_id
183: AND ctl.customer_trx_id = ct.customer_trx_id
184: AND ct.batch_source_id NOT IN (20, 21)
185: AND ct.org_id = pa.org_id (+)

Line 248: pa_implementations pa

244: FROM ra_customer_trx_lines_all ctl,
245: ra_customer_trx_all ct,
246: ra_terms_lines tl,
247: ra_cust_trx_types_all ctt,
248: pa_implementations pa
249: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id
250: AND ctl.customer_trx_id = ct.customer_trx_id
251: AND ct.batch_source_id NOT IN (20, 21)
252: AND ct.org_id = pa.org_id (+)

Line 346: pa_implementations pa

342: ctl.org_id
343: FROM ra_customer_trx_lines_all ctl,
344: ra_customer_trx_all ct,
345: ra_cust_trx_types_all ctt,
346: pa_implementations pa
347: WHERE ctl.request_id = p_request_id
348: AND ctl.customer_trx_id = ct.customer_trx_id
349: AND ct.batch_source_id NOT IN (20, 21)
350: AND ct.org_id = pa.org_id (+)

Line 414: pa_implementations pa

410: ctl.org_id
411: FROM ra_customer_trx_lines_all ctl,
412: ra_customer_trx_all ct,
413: ra_cust_trx_types_all ctt,
414: pa_implementations pa
415: WHERE ctl.request_id = p_request_id
416: AND ctl.customer_trx_id = ct.customer_trx_id
417: AND ct.batch_source_id NOT IN (20, 21)
418: AND ct.org_id = pa.org_id (+)

Line 479: pa_implementations pa

475: ctl.org_id
476: FROM ra_customer_trx_lines_all ctl,
477: ra_customer_trx_all ct,
478: ra_cust_trx_types_all ctt,
479: pa_implementations pa
480: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id
481: AND ctl.customer_trx_id = ct.customer_trx_id
482: AND ct.batch_source_id NOT IN (20, 21)
483: AND ct.org_id = pa.org_id (+)

Line 1776: pa_implementations pa

1772: ar_deferral_reasons dr,
1773: ra_customer_trx_lines ctl,
1774: ra_customer_trx ct,
1775: ra_cust_trx_types ctt,
1776: pa_implementations pa
1777: WHERE rbr.result_value = dr.contingency_id
1778: AND rbr.id = ctl.customer_trx_line_id
1779: AND ctl.customer_trx_id = ct.customer_trx_id
1780: AND ctl.request_id = p_request_id -- 7039838

Line 1853: pa_implementations pa

1849: ar_deferral_reasons dr,
1850: ra_customer_trx_lines ctl,
1851: ra_customer_trx ct,
1852: ra_cust_trx_types ctt,
1853: pa_implementations pa
1854: WHERE rbr.result_value = dr.contingency_id
1855: AND rbr.id = ctl.customer_trx_line_id
1856: AND ctl.customer_trx_id = ct.customer_trx_id
1857: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 1970: pa_implementations pa

1966: ar_trx_header_gt thg,
1967: ra_cust_trx_types ctt,
1968: ar_trx_contingencies_gt tcg,
1969: ar_deferral_reasons dr,
1970: pa_implementations pa
1971: WHERE tlg.request_id = p_request_id
1972: AND tlg.trx_header_id = thg.trx_header_id
1973: AND thg.batch_source_id NOT IN (20, 21)
1974: AND thg.org_id = pa.org_id (+)

Line 2081: pa_implementations pa

2077: ra_customer_trx ct,
2078: ra_cust_trx_types ctt,
2079: ar_interface_conts ic,
2080: ar_deferral_reasons dr,
2081: pa_implementations pa
2082: WHERE ctl.request_id = p_request_id
2083: AND ctl.customer_trx_id = ct.customer_trx_id
2084: AND ct.batch_source_id NOT IN (20, 21)
2085: AND ct.org_id = pa.org_id (+)