APPS.PAY_MX_SSAFFL_SALARY dependencies on PAY_MX_LEGISLATION_INFO_F

Line 37: pay_mx_legislation_info_f table.

33: 02-DEC-2004 kthirmiy 115.1 round idw to 2 decimal and archive
34: 03-Jan-2005 kthirmiy 115.2 4084628 IDW is limited to 25 times of minimum wages
35: of Zone A for reporting purposes
36: 07-Jan-2005 kthirmiy 115.3 4104743 Default Implementation date is derived from
37: pay_mx_legislation_info_f table.
38: 20-Jan-2005 ardsouza 115.4 4129001 Added business_group_id parameter in
39: calls to procedure "per_mx_ssaffl_
40: archive.derive_gre_from_loc_scl".
41: 16-Feb-2005 kthirmiy 115.5 4184215 Changed MXIDWF and to MXIDWV to

Line 1035: from pay_mx_legislation_info_f

1031: -- cursor to get the minimum wage for Zone A
1032: cursor c_minimum_wage_zonea (cp_effective_date in date )
1033: is
1034: select legislation_info2
1035: from pay_mx_legislation_info_f
1036: where legislation_info_type='MX Minimum Wage Information'
1037: and legislation_info1='MWA'
1038: and cp_effective_date between effective_start_date and effective_end_date ;
1039: