APPS.ARP_AUTO_RULE dependencies on ARPT_SQL_FUNC_UTIL

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

1753: WHERE customer_trx_id = p_trx_id;
1754:
1755: arp_standard.debug(' prev ct id ' || l_prev_cust_trx_id);
1756:
1757: l_ctt_type := arpt_sql_func_util.get_trx_type_details(l_ctt_id, 'TYPE') ;
1758: arp_standard.debug(' l_ctt_type ' || l_ctt_type);
1759:
1760: IF l_ctt_type = 'CM' AND
1761: g_use_inv_acctg = 'Y'

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

1761: g_use_inv_acctg = 'Y'
1762: THEN
1763: /* 5598773 - no reason to get the l_revrec_run_flag if
1764: use_inv_acctg is 'N' */
1765: l_revrec_run_flag := arpt_sql_func_util.get_revenue_recog_run_flag(l_prev_cust_trx_id,
1766: l_inv_rule_id);
1767: arp_standard.debug(' l_revrec_run_flag ' || l_revrec_run_flag);
1768: END IF;
1769: