APPS.GL_FC_XLATE_PKG dependencies on GL_LEDGER_RELATIONSHIPS

Line 14: FROM gl_ledger_relationships

10: SELECT 1
11: FROM DUAL
12: WHERE EXISTS
13: (SELECT primary_ledger_id
14: FROM gl_ledger_relationships
15: WHERE target_ledger_name = target_lname);
16: BEGIN
17: target_lname := substrb(ldg_name,1,(27-lengthb(tcurr_code)))
18: ||' ('||tcurr_code||')';

Line 51: FROM gl_ledger_relationships

47: SELECT 1
48: FROM DUAL
49: WHERE EXISTS
50: (SELECT primary_ledger_id
51: FROM gl_ledger_relationships
52: WHERE target_ledger_short_name = target_lshort_name);
53: BEGIN
54: target_lshort_name := substrb(ldg_short_name,1,(17-lengthb(tcurr_code)))
55: ||' ('||tcurr_code||')';

Line 84: FROM gl_ledger_relationships

80: tgt_ldg_name VARCHAR2(30);
81:
82: CURSOR get_existing_ledger_name IS
83: SELECT target_ledger_name
84: FROM gl_ledger_relationships
85: WHERE target_ledger_id = ldg_id
86: AND target_currency_code = tcurr_code
87: AND application_id = 101
88: AND org_id = -99

Line 116: FROM gl_ledger_relationships

112: tgt_ldg_short_name VARCHAR2(30);
113:
114: CURSOR get_existing_ledger_short_name IS
115: SELECT target_ledger_short_name
116: FROM gl_ledger_relationships
117: WHERE target_ledger_id = ldg_id
118: AND target_currency_code = tcurr_code
119: AND application_id = 101
120: AND org_id = -99

Line 154: from gl_ledger_relationships lr

150: and l.object_type_code = 'L'
151: and l.ledger_category_code in ('PRIMARY','SECONDARY')
152: and not exists
153: (select 1
154: from gl_ledger_relationships lr
155: where lr.source_ledger_id = l.ledger_id
156: and lr.target_ledger_id = l.ledger_id
157: and lr.target_ledger_category_code = 'ALC'
158: and lr.relationship_type_code = 'BALANCE'