APPS.PAY_CA_EMP_PRVTAX_INF_API dependencies on HR_LOOKUPS

Line 1186: select '1' from hr_lookups lkp

1182:
1183: procedure check_province_code(p_province_code in varchar2) is
1184:
1185: cursor csr_province_code is
1186: select '1' from hr_lookups lkp
1187: where lkp.lookup_code = p_province_code
1188: and lkp.lookup_type = 'CA_PROVINCE';
1189:
1190: l_province_code varchar2(30);