DBA Data[Home] [Help]

APPS.PAY_SIV_BUS dependencies on HR_LOOKUPS

Line 339: if hr_api.not_exists_in_hr_lookups

335: end if;
336: --
337: -- Do the lookup check.
338: --
339: if hr_api.not_exists_in_hr_lookups
340: (p_effective_date => p_effective_date
341: ,p_lookup_type => p_lookup_type
342: ,p_lookup_code => p_lookup_code
343: )

Line 512: from hr_lookups hr

508: -- Cursor to check that lookup_type is valid.
509: --
510: cursor csr_lookup_type_valid is
511: select null
512: from hr_lookups hr
513: where hr.lookup_type = p_lookup_type
514: and hr.enabled_flag = 'Y'
515: and p_effective_date between
516: nvl(start_date_active, p_effective_date)

Line 584: hr_api.not_exists_in_hr_lookups

580: not l_api_updating or
581: l_chk_default
582: then
583: if p_default_value is not null and p_lookup_type is not null and
584: hr_api.not_exists_in_hr_lookups
585: (p_effective_date => p_effective_date
586: ,p_lookup_type => p_lookup_type
587: ,p_lookup_code => p_default_value
588: )

Line 620: from hr_lookups hr

616: -- Cursor to check that lookup_type is valid.
617: --
618: cursor csr_lookup_type_valid is
619: select null
620: from hr_lookups hr
621: where hr.lookup_type = p_lookup_type
622: and hr.enabled_flag = 'Y'
623: and p_effective_date between
624: nvl(start_date_active, p_effective_date)