1421: slga.ledger_id,
1422: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_SOURCE_NAME) je_source_name,
1423: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_CATEGORY_NAME) je_category_name
1424: FROM fii_slg_assignments slga,
1425: gl_je_inclusion_rules rule,
1426: fii_source_ledger_groups fslg
1427: WHERE slga.je_rule_set_id = rule.je_rule_set_id (+)
1428: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
1429: AND fslg.usage_code = g_usage_code) fset,
1993: slga.ledger_id,
1994: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_SOURCE_NAME) je_source_name,
1995: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_CATEGORY_NAME) je_category_name
1996: FROM fii_slg_assignments slga,
1997: gl_je_inclusion_rules rule,
1998: fii_source_ledger_groups fslg
1999: WHERE slga.je_rule_set_id = rule.je_rule_set_id (+)
2000: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
2001: AND fslg.usage_code = g_usage_code) fset,
2042: slga.ledger_id,
2043: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_SOURCE_NAME) je_source_name,
2044: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_CATEGORY_NAME) je_category_name
2045: FROM fii_slg_assignments slga,
2046: gl_je_inclusion_rules rule,
2047: fii_source_ledger_groups fslg
2048: WHERE slga.je_rule_set_id = rule.je_rule_set_id (+)
2049: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
2050: AND fslg.usage_code = g_usage_code) fset,