1338: WHERE b.gt_id = p_app_rec.gt_id
1339: AND b.app_level = p_app_rec.app_level
1340: AND b.REF_CUSTOMER_TRX_LINE_ID = c.customer_trx_line_id;
1341:
1342: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1339: AND b.app_level = p_app_rec.app_level
1340: AND b.REF_CUSTOMER_TRX_LINE_ID = c.customer_trx_line_id;
1341:
1342: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1340: AND b.REF_CUSTOMER_TRX_LINE_ID = c.customer_trx_line_id;
1341:
1342: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1341:
1342: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1342: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1351: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1351: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1352: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1345: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1351: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1352: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1353: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;
1346: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1351: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1352: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1353: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;
1354: l_last_fetch BOOLEAN := FALSE;
1347: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1351: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1352: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1353: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;
1354: l_last_fetch BOOLEAN := FALSE;
1355: BEGIN
1348: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1351: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1352: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1353: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;
1354: l_last_fetch BOOLEAN := FALSE;
1355: BEGIN
1356: arp_standard.debug('res_ctl_rem_amt_for_app +');
1349: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1351: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1352: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1353: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;
1354: l_last_fetch BOOLEAN := FALSE;
1355: BEGIN
1356: arp_standard.debug('res_ctl_rem_amt_for_app +');
1357: disp_app_rec(p_app_rec);