DBA Data[Home] [Help]

APPS.GL_MC_CURRENCY_PKG dependencies on GL_LEDGER_RELATIONSHIPS

Line 101: , 'retrieving setup data from GL ledger relationships' );

97:
98: IF (G_PROC_LEVEL >= G_STATEMENT_LEVEL )
99: THEN
100: FND_LOG.STRING(G_PROC_LEVEL, l_debug_proc_hdr||'.BEGIN'
101: , 'retrieving setup data from GL ledger relationships' );
102: END IF;
103: -- Retrieve setup from GL ledger relationships
104: SELECT glr.gl_je_conversion_set_id
105: , glr.target_currency_code

Line 103: -- Retrieve setup from GL ledger relationships

99: THEN
100: FND_LOG.STRING(G_PROC_LEVEL, l_debug_proc_hdr||'.BEGIN'
101: , 'retrieving setup data from GL ledger relationships' );
102: END IF;
103: -- Retrieve setup from GL ledger relationships
104: SELECT glr.gl_je_conversion_set_id
105: , glr.target_currency_code
106: , glr.alc_default_conv_rate_type
107: , glr.alc_no_rate_action_code

Line 116: FROM gl_ledger_relationships glr

112: , l_conversion_type
113: , l_no_rate_action
114: , l_inherit_ctype_flag
115: , l_mrc_max_roll_rate
116: FROM gl_ledger_relationships glr
117: WHERE glr.source_ledger_id = p_primary_set_of_books_id
118: AND glr.target_ledger_id = p_reporting_set_of_books_id
119: AND glr.relationship_type_code IN ('JOURNAL', 'SUBLEDGER')
120: AND glr.target_ledger_category_code = 'ALC'