APPS.ARP_ADJUSTMENTS_PKG dependencies on RA_CUST_TRX_TYPES

Line 97: l_adj_post_to_gl_flag ra_cust_trx_types.adj_post_to_gl%type;

93: fnd_currencies.minimum_accountable_unit%type)
94: IS
95:
96: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
97: l_adj_post_to_gl_flag ra_cust_trx_types.adj_post_to_gl%type;
98:
99: BEGIN
100:
101: arp_util.debug('arp_adjustments_pkg.bind_adj_variables()+');

Line 135: FROM ra_customer_trx ct,ra_cust_trx_types ctt

131:
132: /*Bug 7461503 Changes for adjustment posting */
133: SELECT decode(ctt.post_to_gl,'Y','Y' ,nvl(ctt.adj_post_to_gl,'N'))
134: INTO l_adj_post_to_gl_flag
135: FROM ra_customer_trx ct,ra_cust_trx_types ctt
136: WHERE ct.customer_trx_id=p_adj_rec.customer_trx_id
137: AND ctt.cust_trx_type_id=ct.cust_trx_type_id;
138:
139: IF l_adj_post_to_gl_flag = 'Y' THEN

Line 2969: l_adj_post_to_gl_flag ra_cust_trx_types.adj_post_to_gl%type;

2965:
2966: l_adjustment_id ar_adjustments.adjustment_id%type;
2967: l_adjustment_number ar_adjustments.adjustment_number%type;
2968: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
2969: l_adj_post_to_gl_flag ra_cust_trx_types.adj_post_to_gl%type;
2970:
2971: BEGIN
2972:
2973: arp_util.debug('arp_adjustments_pkg.insert_p()+');

Line 3002: FROM ra_customer_trx ct,ra_cust_trx_types ctt

2998: /* Bug 7461503 get value of added flag in transaction types*/
2999:
3000: SELECT decode(ctt.post_to_gl,'Y','Y', nvl(ctt.adj_post_to_gl ,'N'))
3001: INTO l_adj_post_to_gl_flag
3002: FROM ra_customer_trx ct,ra_cust_trx_types ctt
3003: WHERE ct.customer_trx_id=p_adj_rec.customer_trx_id
3004: AND ctt.cust_trx_type_id=ct.cust_trx_type_id;
3005:
3006: