[Home] [Help]
68: gl_ledgers_public_v s,
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
240: FROM xla_post_acct_progs_b XPAP,
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'
259: FROM xla_post_acct_progs_b XPAP,
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'
948: gl_ledgers_public_v s
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
1024: gl_ledgers_public_v s
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