APPS.HR_AMM_BUS dependencies on HR_AUTHORIA_MAPPINGS

Line 391: from hr_authoria_mappings

387: l_proc varchar2(72) := g_package||'chk_unique_ins';
388:
389: cursor csr_chk_unique is
390: select null
391: from hr_authoria_mappings
392: where pl_id = p_pl_id
393: and nvl(plip_id,-924926578) = nvl(p_plip_id,-924926578)
394: and open_enrollment_flag = p_open_enrollment_flag;
395:

Line 462: from hr_authoria_mappings

458: l_proc varchar2(72) := g_package||'chk_unique_upd';
459:
460: cursor csr_chk_unique is
461: select null
462: from hr_authoria_mappings
463: where pl_id = p_pl_id
464: and nvl(plip_id,-924926578) = nvl(p_plip_id,-924926578)
465: and open_enrollment_flag = p_open_enrollment_flag
466: and authoria_mapping_id <> p_authoria_mapping_id;