APPS.PQP_GB_OMP_TEMPLATE dependencies on HR_API

Line 220: AND nvl(hrl.end_date_active,hr_api.g_eot);

216: WHERE lookup_type = 'PQP_GAP_ENTITLEMENT_BANDS'
217: AND NVL(enabled_flag,'Y') = 'Y'
218: AND lookup_code like 'BAND%'
219: AND c_effective_date BETWEEN hrl.start_date_active
220: AND nvl(hrl.end_date_active,hr_api.g_eot);
221:
222: CURSOR csr_chk_primary_exists is
223: SELECT 'X'
224: FROM pay_element_type_extra_info

Line 624: ,nvl(p_effective_end_date, hr_api.g_eot)

620: )
621: VALUES
622: (l_user_row_id
623: ,p_effective_start_date
624: ,nvl(p_effective_end_date, hr_api.g_eot)
625: ,p_udt_rows(i).business_group_id
626: ,p_udt_rows(i).legislation_code
627: ,l_user_table_id
628: ,p_udt_rows(i).row_low_range_or_name