APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on AR_TRX_CONTINGENCIES_GT

Line 1968: ar_trx_contingencies_gt tcg,

1964: thg.org_id
1965: FROM ar_trx_lines_gt tlg,
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

Line 2215: ar_trx_contingencies_gt tcg,

2211: sysdate,
2212: thg.org_id
2213: FROM ar_trx_header_gt thg,
2214: ar_trx_lines_gt tlg,
2215: ar_trx_contingencies_gt tcg,
2216: ar_line_conts lrc
2217: WHERE tlg.request_id = p_request_id
2218: AND tlg.customer_trx_id = thg.customer_trx_id
2219: AND tlg.customer_trx_line_id = lrc.customer_trx_line_id

Line 2561: ar_trx_contingencies_gt cgt

2557: arp_standard.fnd_message('AR_RVMG_INVALID_CONTINGENCY'),
2558: cgt.contingency_id
2559: FROM ar_trx_lines_gt lgt,
2560: ar_trx_header_gt hgt,
2561: ar_trx_contingencies_gt cgt
2562: WHERE lgt.trx_header_id = hgt.trx_header_id
2563: AND cgt.trx_line_id = lgt.trx_line_id
2564: AND NOT EXISTS
2565: (

Line 2602: ar_trx_contingencies_gt cgt,

2598: arp_standard.fnd_message('AR_RVMG_NO_EXP_DATE'),
2599: cgt.contingency_id
2600: FROM ar_trx_lines_gt lgt,
2601: ar_trx_header_gt hgt,
2602: ar_trx_contingencies_gt cgt,
2603: ar_deferral_reasons dr
2604: WHERE lgt.trx_header_id = hgt.trx_header_id
2605: AND cgt.trx_line_id = lgt.trx_line_id
2606: AND cgt.contingency_id = dr.contingency_id

Line 5987: delete from ar_trx_contingencies_gt;

5983: delete from ar_trx_header_gt;
5984: delete from ar_trx_lines_gt;
5985: delete from ar_reviewed_lines_gt;
5986: delete from fun_rule_bulk_result_gt;
5987: delete from ar_trx_contingencies_gt;
5988:
5989: populate_acceptance_rows;
5990: populate_child_rows;
5991: