[Home] [Help]
69: fa_deprn_periods dp,
70: fa_book_controls bc,
71: (SELECT DISTINCT slga.ledger_id
72: FROM fii_slg_assignments slga,
73: fii_source_ledger_groups fslg
74: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id
75: AND fslg.usage_code = g_usage_code) fset
76: WHERE s.ledger_id = fset.ledger_id
77: AND ps.application_id = 101
241: xla_assignment_defns_b XAD,
242: xla_acct_class_assgns XACA,
243: (SELECT DISTINCT slga.ledger_id
244: FROM fii_slg_assignments slga,
245: fii_source_ledger_groups fslg
246: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id
247: AND fslg.usage_code = g_usage_code) fset
248: WHERE XPAP.program_owner_code = 'S'
249: AND XPAP.program_code = 'ASSETS DBI EXPENSES'
260: xla_assignment_defns_b XAD,
261: xla_acct_class_assgns XACA,
262: (SELECT DISTINCT slga.ledger_id
263: FROM fii_slg_assignments slga,
264: fii_source_ledger_groups fslg
265: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id
266: AND fslg.usage_code = g_usage_code) fset
267: WHERE XPAP.program_owner_code = 'S'
268: AND XPAP.program_code = 'ASSETS DBI EXPENSES'
949: WHERE p.end_date >= g_global_Start_Date
950: AND p.period_set_name = s.period_set_name) per,
951: (SELECT DISTINCT slga.ledger_id
952: FROM fii_slg_assignments slga,
953: fii_source_ledger_groups fslg
954: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id
955: AND fslg.usage_code = g_usage_code) fset
956: where xlasl.application_id = 140
957: and glh.JE_SOURCE = xlasl.je_source_name
1025: WHERE p.end_date >= g_global_Start_Date
1026: AND p.period_set_name = s.period_set_name) per,
1027: (SELECT DISTINCT slga.ledger_id
1028: FROM fii_slg_assignments slga,
1029: fii_source_ledger_groups fslg
1030: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id
1031: AND fslg.usage_code = g_usage_code) fset
1032: where xlasl.application_id = 140
1033: and glh.JE_SOURCE = xlasl.je_source_name