APPS.ARP_AUTO_RULE dependencies on ARPT_SQL_FUNC_UTIL

Line 1450: l_ctt_type := arpt_sql_func_util.get_trx_type_details(l_ctt_id, 'TYPE') ;

1446: WHERE customer_trx_id = p_trx_id;
1447:
1448: arp_standard.debug(' prev ct id ' || l_prev_cust_trx_id);
1449:
1450: l_ctt_type := arpt_sql_func_util.get_trx_type_details(l_ctt_id, 'TYPE') ;
1451: arp_standard.debug(' l_ctt_type ' || l_ctt_type);
1452:
1453: IF l_ctt_type = 'CM' AND
1454: g_use_inv_acctg = 'Y'

Line 1458: l_revrec_run_flag := arpt_sql_func_util.get_revenue_recog_run_flag(l_prev_cust_trx_id,

1454: g_use_inv_acctg = 'Y'
1455: THEN
1456: /* 5598773 - no reason to get the l_revrec_run_flag if
1457: use_inv_acctg is 'N' */
1458: l_revrec_run_flag := arpt_sql_func_util.get_revenue_recog_run_flag(l_prev_cust_trx_id,
1459: l_inv_rule_id);
1460: arp_standard.debug(' l_revrec_run_flag ' || l_revrec_run_flag);
1461: END IF;
1462: