DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on DUAL

Line 2505: from dual

2501: AND x.eff_start_date <= v_transaction_date
2502: AND x.eff_end_date >= v_transaction_date
2503: AND x.delete_mark = 0
2504: ), v_organization_id) organization_id
2505: from dual
2506: ) oasc
2507: WHERE god.organization_id = nvl(oasc.organization_id, v_organization_id)
2508: AND f.legal_entity_id = god.legal_entity_id
2509: AND f.delete_mark = 0

Line 2540: from dual

2536: AND x.eff_start_date <= v_transaction_date
2537: AND x.eff_end_date >= v_transaction_date
2538: AND x.delete_mark = 0
2539: ), v_organization_id) organization_id
2540: from dual
2541: ) oasc
2542: WHERE god.organization_id = nvl(oasc.organization_id, v_organization_id)
2543: AND f.legal_entity_id = god.legal_entity_id
2544: AND f.delete_mark = 0