APPS.PN_EXP_TO_AR dependencies on RA_INTERFACE_DISTRIBUTIONS_ALL

Line 537: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced RA_INTERFACE_DISTRIBUTIONS_ALL

533: -- 10-MAR-05 piagrawa o Bug #4231051 - Truncated the attribute values to 30
534: -- characters before inserting into ra_interface_lines,
535: -- ra_interface_salescredits and
536: -- ra_interface_distributions tables
537: -- 15-JUL-05 hareesha o Bug 4284035 - Replaced RA_INTERFACE_DISTRIBUTIONS_ALL
538: -- with _ALL table.
539: -- 11-OCT-05 pikhar o Bug 4652946 - Added trunc to pi.accounted_date in
540: -- Q_Billitem, l_ord_clause
541: -- 28-OCT-05 sdmahesh o ATG mandated changes for SQL literals

Line 1495: INSERT INTO ra_interface_distributions_all

1491:
1492: l_context := 'Inserting into Distributions for REC acount for this group';
1493: pnp_debug_pkg.log(l_context ||' : '|| exp_ar_tbl(l_grp).rec_account);
1494:
1495: INSERT INTO ra_interface_distributions_all
1496: (account_class
1497: ,percent
1498: ,amount
1499: ,code_combination_id

Line 1638: INSERT INTO ra_interface_distributions_all

1634:
1635: pnp_debug_pkg.log('Inserting into distributions for account types of REV and UNEARN');
1636: l_context := 'Inserting into Distributions for account types of REV and UNEARN';
1637:
1638: INSERT INTO ra_interface_distributions_all
1639: (account_class
1640: ,percent
1641: ,amount
1642: ,code_combination_id

Line 2740: INSERT INTO ra_interface_distributions_all

2736: (NVL(V_NORMALIZE,'N') <> 'Y' OR
2737: (NVL(V_NORMALIZE,'N') = 'Y' AND NVL(l_send_flag,'Y') = 'N'))) THEN
2738:
2739:
2740: INSERT INTO ra_interface_distributions_all
2741: ( account_class
2742: ,percent
2743: ,amount
2744: ,code_combination_id