DBA Data[Home] [Help]

APPS.CE_BANK_ACCT_BALANCE_REPORT dependencies on CE_LE_BG_OU_VS_V

Line 495: from CE_LE_BG_OU_VS_V

491: -- get legal entity name
492: if p_legal_entity_id is not null then
493: select name
494: into l_legal_entity_name
495: from CE_LE_BG_OU_VS_V
496: where legal_entity_id = p_legal_entity_id and organization_type = 'LEGAL_ENTITY';
497: end if;
498:
499: -- loop through all currencies to generate the XML node BankAccttGroupByCurrency

Line 1060: from CE_LE_BG_OU_VS_V

1056:
1057: if p_legal_entity_id is not null then
1058: select name
1059: into l_legal_entity_name
1060: from CE_LE_BG_OU_VS_V
1061: where legal_entity_id = p_legal_entity_id and organization_type = 'LEGAL_ENTITY';
1062: end if;
1063:
1064: if (p_from_date is not null) and p_to_date is not null and p_from_date > p_to_date then

Line 1235: from CE_LE_BG_OU_VS_V

1231:
1232: if p_legal_entity_id is not null then
1233: select name
1234: into l_legal_entity_name
1235: from CE_LE_BG_OU_VS_V
1236: where legal_entity_id = p_legal_entity_id and organization_type = 'LEGAL_ENTITY';
1237: end if;
1238:
1239: if (p_from_date is not null) and p_to_date is not null and p_from_date > p_to_date then