APPS.AR_INVOICE_UTILS dependencies on RA_RULES

Line 5619: ra_rules rr

5615: line.ACCOUNTING_RULE_ID, line.ACCOUNTING_RULE_DURATION,
5616: line.RULE_START_DATE,line.RULE_END_DATE,line.set_of_books_id,hdr.trx_date,
5617: rr.type, rr.frequency, rr.occurrences
5618: FROM ar_trx_lines_gt line, ar_trx_header_gt hdr,
5619: ra_rules rr
5620: WHERE hdr.invoicing_rule_id IS NOT NULL
5621: AND line.accounting_rule_id IS NOT NULL
5622: AND hdr.trx_header_id = line.trx_header_id
5623: AND hdr.trx_class <> 'CM' -- Added for ER 5869149

Line 5650: FROM ra_rules rr

5646: AND gt2.trx_header_id = gt.trx_header_id
5647: AND gt2.trx_class <> 'CM' -- Added for ER 5869149
5648: AND NOT EXISTS (
5649: SELECT 'X'
5650: FROM ra_rules rr
5651: WHERE rr.type in ('A', 'ACC_DUR','PP_DR_ALL','PP_DR_PP')
5652: and rr.status = 'A'
5653: AND rr.rule_id = gt.accounting_rule_id);
5654:

Line 5734: ra_rules rr2,

5730: UPDATE ar_trx_lines_gt a
5731: SET ACCOUNTING_RULE_DURATION =
5732: (SELECT COUNT(*)
5733: FROM ar_periods gps,
5734: ra_rules rr2,
5735: ar_system_parameters sys,
5736: gl_sets_of_books gl
5737: WHERE
5738: rr2.rule_id = a.ACCOUNTING_RULE_ID