DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 5830: from PAY_CA_EMP_PROV_TAX_INFO_F rules,

5826: l_ovn number;
5827: begin
5828: select rules.object_version_number
5829: into l_ovn
5830: from PAY_CA_EMP_PROV_TAX_INFO_F rules,
5831: hr_pump_batch_line_user_keys key
5832: where key.user_key_value = P_EMP_PROV_TAX_INF_USER_KEY
5833: and rules.EMP_PROVINCE_TAX_INF_ID = key.unique_key_id
5834: and p_effective_date between