APPS.GL_LEDGER_UTILS_PKG dependencies on GL_LEDGER_RELATIONSHIPS

Line 22: FROM GL_LEDGER_RELATIONSHIPS

18:
19: CURSOR c_ledger_relationship IS
20: SELECT target_ledger_id, target_currency_code,
21: decode(relationship_type_code, 'BALANCE', 'Y', 'N')
22: FROM GL_LEDGER_RELATIONSHIPS
23: WHERE target_ledger_short_name = X_Ledger_Short_Name;
24: BEGIN
25: OPEN c_ledger;
26: FETCH c_ledger INTO X_Ledger_Id, X_Ledger_Currency, X_Translated_Flag;

Line 57: FROM GL_LEDGER_RELATIONSHIPS

53:
54: CURSOR c_ledger_relationship IS
55: SELECT target_ledger_short_name,
56: decode(relationship_type_code, 'BALANCE', 'Y', 'N')
57: FROM GL_LEDGER_RELATIONSHIPS
58: WHERE target_ledger_id = X_Ledger_Id
59: AND target_currency_code = X_Ledger_Currency
60: AND application_id = 101;
61: BEGIN

Line 97: FROM GL_LEDGER_RELATIONSHIPS

93: RETURN VARCHAR2
94: IS
95: CURSOR c_ledger IS
96: SELECT target_currency_code
97: FROM GL_LEDGER_RELATIONSHIPS
98: WHERE target_ledger_short_name = X_Ledger_Short_Name;
99:
100: CURSOR c_ledger_set IS
101: SELECT currency_code

Line 138: GL_LEDGER_RELATIONSHIPS LR

134: IS
135: CURSOR LedgerID(p_ledger_set_id number, p_ledger_currency varchar2) IS
136: SELECT TARGET_LEDGER_ID
137: FROM GL_LEDGER_SET_ASSIGNMENTS ASG,
138: GL_LEDGER_RELATIONSHIPS LR
139: WHERE ASG.LEDGER_SET_ID = P_LEDGER_SET_ID
140: AND LR.TARGET_LEDGER_ID = ASG.LEDGER_ID
141: AND LR.SOURCE_LEDGER_ID = ASG.LEDGER_ID
142: AND LR.TARGET_CURRENCY_CODE = P_LEDGER_CURRENCY;