APPS.AR_INVOICE_UTILS dependencies on RA_RULES

Line 5491: ra_rules rr

5487: line.ACCOUNTING_RULE_ID, line.ACCOUNTING_RULE_DURATION,
5488: line.RULE_START_DATE,line.RULE_END_DATE,line.set_of_books_id,hdr.trx_date,
5489: rr.type, rr.frequency, rr.occurrences
5490: FROM ar_trx_lines_gt line, ar_trx_header_gt hdr,
5491: ra_rules rr
5492: WHERE hdr.invoicing_rule_id IS NOT NULL
5493: AND line.accounting_rule_id IS NOT NULL
5494: AND hdr.trx_header_id = line.trx_header_id
5495: AND hdr.trx_class <> 'CM' -- Added for ER 5869149

Line 5522: FROM ra_rules rr

5518: AND gt2.trx_header_id = gt.trx_header_id
5519: AND gt2.trx_class <> 'CM' -- Added for ER 5869149
5520: AND NOT EXISTS (
5521: SELECT 'X'
5522: FROM ra_rules rr
5523: WHERE rr.type in ('A', 'ACC_DUR','PP_DR_ALL','PP_DR_PP')
5524: and rr.status = 'A'
5525: AND rr.rule_id = gt.accounting_rule_id);
5526:

Line 5606: ra_rules rr2,

5602: UPDATE ar_trx_lines_gt a
5603: SET ACCOUNTING_RULE_DURATION =
5604: (SELECT COUNT(*)
5605: FROM ar_periods gps,
5606: ra_rules rr2,
5607: ar_system_parameters sys,
5608: gl_sets_of_books gl
5609: WHERE
5610: rr2.rule_id = a.ACCOUNTING_RULE_ID