DBA Data[Home] [Help]

APPS.PAY_CA_EMP_FEDTAX_INF_API dependencies on HR_LOOKUPS

Line 1088: select '1' from hr_lookups lkp

1084:
1085: procedure check_employment_province(p_employment_province in varchar2) is
1086:
1087: cursor csr_employment_province is
1088: select '1' from hr_lookups lkp
1089: where lkp.lookup_code = p_employment_province
1090: and lkp.lookup_type = 'CA_PROVINCE';
1091:
1092: l_employment_province varchar2(30);