DBA Data[Home] [Help]

APPS.PAY_CA_EMP_FEDTAX_INF_API dependencies on HR_LOOKUPS

Line 1104: select '1' from hr_lookups lkp

1100:
1101: procedure check_employment_province(p_employment_province in varchar2) is
1102:
1103: cursor csr_employment_province is
1104: select '1' from hr_lookups lkp
1105: where lkp.lookup_code = p_employment_province
1106: and lkp.lookup_type = 'CA_PROVINCE';
1107:
1108: l_employment_province varchar2(30);