DBA Data[Home] [Help]

APPS.PAY_FR_RULES dependencies on HR_GENERAL

Line 276: AND nvl(org.date_to, hr_general.end_of_time);

272: AND hoi.ORG_INFORMATION2 = l_gen_org_method_id_chr
273: AND hoi.org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO'
274: AND hoi.organization_id = org.organization_id
275: AND p_effective_date between org.date_from
276: AND nvl(org.date_to, hr_general.end_of_time);
277: --
278: open csr_check_opm_effective(p_org_method_id,p_effective_date);
279: fetch csr_check_opm_effective into l_dummy_opm_id;
280: if csr_check_opm_effective%NOTFOUND then

Line 307: AND nvl(org.date_to, hr_general.end_of_time);

303: AND hoi.ORG_INFORMATION2 = l_gen_org_method_id_chr
304: AND hoi.org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO'
305: AND hoi.organization_id = org.organization_id
306: AND p_effective_date between org.date_from
307: AND nvl(org.date_to, hr_general.end_of_time);
308: --
309: open csr_check_opm_effective(p_org_method_id, p_effective_date);
310: fetch csr_check_opm_effective into l_dummy_opm_id;
311: if csr_check_opm_effective%NOTFOUND then