APPS.OTA_DELEGATE_BOOKING_API dependencies on HR_LOOKUPS

Line 1925: FROM hr_lookups

1921: and acct_role.cust_account_role_id = nvl(p_delegate_contact_id,p_contact_id);
1922:
1923: CURSOR csr_hr_lookup( p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS
1924: SELECT meaning
1925: FROM hr_lookups
1926: WHERE lookup_type = p_lookup_type
1927: AND lookup_code = p_lookup_code
1928: AND enabled_flag = 'Y'
1929: AND sysdate between NVL(start_date_active, sysdate) AND NVL(end_date_active, (sysdate+1));