APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on AR_TRX_CONTINGENCIES_GT

Line 1864: ar_trx_contingencies_gt tcg,

1860: thg.org_id
1861: FROM ar_trx_lines_gt tlg,
1862: ar_trx_header_gt thg,
1863: ra_cust_trx_types ctt,
1864: ar_trx_contingencies_gt tcg,
1865: ar_deferral_reasons dr
1866: WHERE tlg.request_id = p_request_id
1867: AND tlg.trx_header_id = thg.trx_header_id
1868: AND thg.batch_source_id NOT IN (20, 21)

Line 2101: ar_trx_contingencies_gt tcg,

2097: sysdate,
2098: thg.org_id
2099: FROM ar_trx_header_gt thg,
2100: ar_trx_lines_gt tlg,
2101: ar_trx_contingencies_gt tcg,
2102: ar_line_conts lrc
2103: WHERE tlg.request_id = p_request_id
2104: AND tlg.customer_trx_id = thg.customer_trx_id
2105: AND tlg.customer_trx_line_id = lrc.customer_trx_line_id

Line 2414: ar_trx_contingencies_gt cgt

2410: arp_standard.fnd_message('AR_RVMG_INVALID_CONTINGENCY'),
2411: cgt.contingency_id
2412: FROM ar_trx_lines_gt lgt,
2413: ar_trx_header_gt hgt,
2414: ar_trx_contingencies_gt cgt
2415: WHERE lgt.trx_header_id = hgt.trx_header_id
2416: AND cgt.trx_line_id = lgt.trx_line_id
2417: AND NOT EXISTS
2418: (

Line 2455: ar_trx_contingencies_gt cgt,

2451: arp_standard.fnd_message('AR_RVMG_NO_EXP_DATE'),
2452: cgt.contingency_id
2453: FROM ar_trx_lines_gt lgt,
2454: ar_trx_header_gt hgt,
2455: ar_trx_contingencies_gt cgt,
2456: ar_deferral_reasons dr
2457: WHERE lgt.trx_header_id = hgt.trx_header_id
2458: AND cgt.trx_line_id = lgt.trx_line_id
2459: AND cgt.contingency_id = dr.contingency_id

Line 5798: delete from ar_trx_contingencies_gt;

5794: delete from ar_trx_header_gt;
5795: delete from ar_trx_lines_gt;
5796: delete from ar_reviewed_lines_gt;
5797: delete from fun_rule_bulk_result_gt;
5798: delete from ar_trx_contingencies_gt;
5799:
5800: populate_acceptance_rows;
5801: populate_child_rows;
5802: