DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on DUAL

Line 2327: from dual

2323: AND x.eff_start_date <= v_transaction_date
2324: AND x.eff_end_date >= v_transaction_date
2325: AND x.delete_mark = 0
2326: ), v_organization_id) organization_id
2327: from dual
2328: ) oasc
2329: WHERE god.organization_id = nvl(oasc.organization_id, v_organization_id)
2330: AND f.legal_entity_id = god.legal_entity_id
2331: AND f.delete_mark = 0

Line 2362: from dual

2358: AND x.eff_start_date <= v_transaction_date
2359: AND x.eff_end_date >= v_transaction_date
2360: AND x.delete_mark = 0
2361: ), v_organization_id) organization_id
2362: from dual
2363: ) oasc
2364: WHERE god.organization_id = nvl(oasc.organization_id, v_organization_id)
2365: AND f.legal_entity_id = god.legal_entity_id
2366: AND f.delete_mark = 0