APPS.ARPT_SQL_FUNC_UTIL dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 302: From ra_cust_trx_line_gl_dist d

298: Select decode(max(DUMMY), null , 'N','Y')
299: Into l_rule_flag
300: From dual
301: Where Exists ( Select 'Revenue recognition has been run'
302: From ra_cust_trx_line_gl_dist d
303: Where d.customer_trx_id = p_customer_trx_id
304: and d.account_class = 'REC'
305: and d.account_set_flag = 'N');
306:

Line 344: ra_cust_trx_line_gl_dist d

340: null, 'N',
341: 'Y')
342: INTO l_rule_flag
343: FROM ra_customer_trx trx,
344: ra_cust_trx_line_gl_dist d
345: WHERE trx.customer_trx_id = p_customer_trx_id
346: and trx.previous_customer_trx_id = d.customer_trx_id
347: and d.account_class in ('UNEARN', 'UNBILL')
348: and d.account_set_flag='N'; Added for bug 559954

Line 463: FROM ra_cust_trx_line_gl_dist

459: INTO l_temp_flag
460: FROM DUAL
461: WHERE EXISTS (
462: SELECT 'transaction has been posted'
463: FROM ra_cust_trx_line_gl_dist
464: WHERE customer_trx_id = p_customer_trx_id
465: AND gl_posted_date IS NOT NULL
466: );
467: END IF;

Line 627: SELECT 'Y' FROM ra_cust_trx_line_gl_dist

623: l_activity_flag varchar2(1);
624:
625: --{verif if 1 distribution has been posted 4897195
626: CURSOR c IS
627: SELECT 'Y' FROM ra_cust_trx_line_gl_dist
628: WHERE customer_trx_id = p_customer_trx_id
629: AND account_set_flag = 'N'
630: AND posting_control_id > 0;
631:

Line 945: FROM ra_cust_trx_line_gl_dist

941: ELSE
942:
943: SELECT DECODE( MAX( gl_posted_date ), NULL, 'N', 'Y')
944: INTO l_activity_flag
945: FROM ra_cust_trx_line_gl_dist
946: WHERE customer_trx_id = p_customer_trx_id;
947:
948: END IF;
949: