DBA Data[Home] [Help]

APPS.POS_VENDOR_REG_PKG dependencies on HR_OPERATING_UNITS

Line 1622: ln_dup hr_operating_units.organization_id%TYPE;

1618: (p_ou_id IN NUMBER
1619: ) RETURN VARCHAR2
1620: IS
1621:
1622: ln_dup hr_operating_units.organization_id%TYPE;
1623:
1624: CURSOR hou_cur IS
1625: SELECT organization_id
1626: FROM hr_operating_units

Line 1626: FROM hr_operating_units

1622: ln_dup hr_operating_units.organization_id%TYPE;
1623:
1624: CURSOR hou_cur IS
1625: SELECT organization_id
1626: FROM hr_operating_units
1627: WHERE organization_id = p_ou_id
1628: AND ( date_to IS NULL OR
1629: ( date_to > sysdate AND date_to > date_from ) );
1630: