eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ARP_CONFIRMATION dependencies on AR_RECEIVABLE_APPLICATIONS_S

Line 1477: SELECT ar_receivable_applications_s.nextval

1473: --Retrieve sequence id for receivable application id of UNAPP record
1474: --Note as this procedure creates a single UNAPP record hence this kind
1475: --of select from dual for sequence id is done
1476:
1477: SELECT ar_receivable_applications_s.nextval
1478: INTO l_unapp_id
1479: FROM dual;
1480:
1481: --Insert negative UNAPP record for confirmed APP record

Line 2114: SELECT ar_receivable_applications_s.nextval

2110:
2111: FOR l_app_rec IN get_app LOOP
2112:
2113: --retrieve sequence
2114: SELECT ar_receivable_applications_s.nextval
2115: INTO l_new_app_id
2116: FROM dual;
2117:
2118: --Create actual reversing apps

Line 2291: ar_receivable_applications_s.nextval,

2287: -- create new unconfirmed records from old confirmed records:
2288:
2289: SELECT
2290: receivable_application_id,
2291: ar_receivable_applications_s.nextval,
2292: acctd_amount_applied_from,
2293: amount_applied,
2294: DECODE(status,
2295: 'UNAPP', '40.0',