DBA Data[Home] [Help]

APPS.POS_VENDOR_REG_PKG dependencies on HR_OPERATING_UNITS

Line 1361: ln_dup hr_operating_units.organization_id%TYPE;

1357: (p_ou_id IN NUMBER
1358: ) RETURN VARCHAR2
1359: IS
1360:
1361: ln_dup hr_operating_units.organization_id%TYPE;
1362:
1363: CURSOR hou_cur IS
1364: SELECT organization_id
1365: FROM hr_operating_units

Line 1365: FROM hr_operating_units

1361: ln_dup hr_operating_units.organization_id%TYPE;
1362:
1363: CURSOR hou_cur IS
1364: SELECT organization_id
1365: FROM hr_operating_units
1366: WHERE organization_id = p_ou_id
1367: AND ( date_to IS NULL OR
1368: ( date_to > sysdate AND date_to > date_from ) );
1369: