APPS.GMF_LEGAL_ENTITY_TZ SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 68

    SELECT      organization_id
    FROM        org_organization_definitions
    WHERE       legal_entity = p_le_id
    AND         nvl(inventory_enabled_flag, 'N') = 'Y'
    AND         ROWNUM = 1;

Line: 123

    SELECT    org_id
    FROM      gl_plcy_mst
    WHERE     co_code = c_co_code;

Line: 171

    SELECT    org_id
    FROM      gl_plcy_mst plc
    WHERE     plc.co_code = c_co_code;

Line: 251

    SELECT      org_id
    FROM        gl_plcy_mst
    WHERE       co_code = c_co_code;