APPS.FV_FACTS_TRX_REGISTER dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 917: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;

913:
914: l_sla_hdr_event_id NUMBER;
915: l_sla_hdr_creation_date DATE;
916: l_sla_entity_id NUMBER;
917: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
918: l_get_trx_part_from_reimb BOOLEAN;
919:
920: BEGIN
921: l_module_name := g_module_name || 'journal_process';

Line 2154: --customer_trx_line_id will be null in ra_cust_trx_line_gl_dist_all

2150: l_category = 'Debit Memos')
2151: ) THEN
2152: BEGIN
2153: --Bug 7121539
2154: --customer_trx_line_id will be null in ra_cust_trx_line_gl_dist_all
2155: --for account class 'REC', hence using customer_trx_id to get
2156: --details instead of customer_trx_line_id for these distributions
2157: SELECT account_class
2158: INTO l_account_class

Line 2159: FROM ra_cust_trx_line_gl_dist_all

2155: --for account class 'REC', hence using customer_trx_id to get
2156: --details instead of customer_trx_line_id for these distributions
2157: SELECT account_class
2158: INTO l_account_class
2159: FROM ra_cust_trx_line_gl_dist_all
2160: WHERE cust_trx_line_gl_dist_id = l_source_distribution_id_num_1;
2161:
2162: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2163: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

Line 2174: FROM ra_cust_trx_line_gl_dist_all rctgl,

2170: rcth.customer_trx_id
2171: INTO l_reference_4,
2172: l_reference_7,
2173: l_reference_2
2174: FROM ra_cust_trx_line_gl_dist_all rctgl,
2175: ra_customer_trx_lines_all rctl,
2176: ra_customer_trx_all rcth
2177: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2178: AND rctl.customer_trx_line_id = rctgl.customer_trx_line_id

Line 2187: FROM ra_cust_trx_line_gl_dist_all rctgl,

2183: rcth.customer_trx_id
2184: INTO l_reference_4,
2185: l_reference_7,
2186: l_reference_2
2187: FROM ra_cust_trx_line_gl_dist_all rctgl,
2188: ra_customer_trx_all rcth
2189: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2190: AND rcth.customer_trx_id = rctgl.customer_trx_id;
2191: END IF;