DBA Data[Home] [Help]

APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_MX_LEGISLATION_INFO_F

Line 854: FROM pay_mx_legislation_info_f

850: RETURN NUMBER IS
851:
852: CURSOR c_minimum_wage_zonea( cp_effective_date DATE ) IS
853: SELECT fnd_number.canonical_to_number(legislation_info2)
854: FROM pay_mx_legislation_info_f
855: WHERE legislation_info_type = 'MX Minimum Wage Information'
856: AND legislation_info1 = 'MWA'
857: AND cp_effective_date BETWEEN effective_start_date
858: AND effective_end_date;