DBA Data[Home] [Help]

APPS.PER_SSM_BUS dependencies on HR_LOOKUPS

Line 992: -- p_company_age_code code for lookup in hr_lookups

988: -- None.
989: --
990: -- In Parameters
991: -- p_salary_survey_mapping_id PK
992: -- p_company_age_code code for lookup in hr_lookups
993: -- p_object_version_number object version number
994: --
995: -- Post Success
996: -- Processing continues If the lookup exists in the lookup table.

Line 1017: from hr_lookups l

1013: l_exists varchar2(1);
1014: --
1015: cursor csr_chk_company_age_exists is
1016: select 'Y'
1017: from hr_lookups l
1018: where l.lookup_code = p_company_age_code
1019: and l.lookup_type = 'COMPANY_AGE'
1020: and l.enabled_flag = 'Y';
1021: --