APPS.GL_MC_INFO dependencies on GL_LEDGER_LE_V

Line 721: FROM GL_LEDGER_LE_V

717: l_rec_col.ledger_name,
718: l_rec_col.ledger_short_name,
719: l_rec_col.ledger_currency,
720: l_rec_col.ledger_category
721: FROM GL_LEDGER_LE_V
722: WHERE ledger_category_code IN (
723: DECODE(UPPER(NVL(p_get_primary_flag, 'Y')), 'Y', 'PRIMARY', 'NOT_INCLUDED'),
724: DECODE(UPPER(NVL(p_get_secondary_flag, 'N')), 'Y', 'SECONDARY', 'NOT_INCLUDED'),
725: DECODE(UPPER(NVL(p_get_alc_flag, 'N')), 'Y', 'ALC', 'NOT_INCLUDED'))

Line 781: FROM GL_LEDGER_LE_V

777: , legal_entity_name
778: BULK COLLECT INTO
779: l_rec_col.legal_entity_id,
780: l_rec_col.legal_entity_name
781: FROM GL_LEDGER_LE_V
782: WHERE ledger_id = p_ledger_id
783: AND legal_entity_id IS NOT NULL
784: AND relationship_enabled_flag = 'Y'
785: ORDER BY legal_entity_id;

Line 924: ** -- from GL_LEDGER_LE_V

920: ** -- CASE 3: All BSV option and BSV is passed
921: ** -- First, we need to check whether the passed BSV is assigned to
922: ** -- this edger.
923: ** -- => If yes, it can proceed to get LEs assigned to this ledger
924: ** -- from GL_LEDGER_LE_V
925: ** -- => If no, it will return TRUE and null LE list.
926: ** BEGIN
927: ** SELECT 'Y'
928: ** INTO l_bsv_assigned

Line 945: -- GL_LEDGER_LE_V

941: *********************************************************/
942:
943: -- CASE 4: All BSV option and BSV is not passed (*Also for CASE 3)
944: -- We can call another API to get LEs assigned this ledger from
945: -- GL_LEDGER_LE_V
946: RETURN GL_MC_INFO.get_legal_entities(p_ledger_id, x_le_list);
947:
948: ELSE
949: -- Invalid BSV option code

Line 1053: FROM GL_LEDGER_LE_V

1049: -- => If no, it will return TRUE and null BSV list
1050: BEGIN
1051: SELECT legal_entity_name
1052: INTO l_le_name
1053: FROM GL_LEDGER_LE_V
1054: WHERE ledger_id = l_ledger_id
1055: AND legal_entity_id = p_legal_entity_id
1056: AND relationship_enabled_flag = 'Y';
1057: EXCEPTION