APPS.PER_MX_SSAFFL_ARCHIVE dependencies on PAY_MX_LEGISLATION_INFO_F

Line 85: pay_mx_legislation_info_f table.

81: 02-Dec-2004 kthirmiy 115.16 round idw to 2 decimal and archive
82: 03-Jan-2005 kthirmiy 115.17 4084628 IDW is limited to 25 times of minimum wages
83: of Zone A for reporting purposes
84: 07-Jan-2005 kthirmiy 115.18 4104743 Default Implementation date is derived from
85: pay_mx_legislation_info_f table.
86: 07-Jan-2005 kthirmiy 115.19 fixed gscc error
87: 20-Jan-2005 ardsouza 115.20 4129001 Added p_business_group_id parameter to
88: procedure "derive_gre_from_loc_scl".
89: 06-May-2005 kthirmiy 115.21 4353084 removed the redundant use of bind variable

Line 162: from pay_mx_legislation_info_f table

158:
159: /******************************************************************************
160: Name : get_default_imp_date
161: Purpose : This function returns the default implementation date
162: from pay_mx_legislation_info_f table
163: ******************************************************************************/
164: FUNCTION get_default_imp_date
165: RETURN VARCHAR2
166: IS

Line 171: from pay_mx_legislation_info_f

167:
168: cursor c_get_def_imp_date
169: is
170: select fnd_date.canonical_to_date(legislation_info1)
171: from pay_mx_legislation_info_f
172: where legislation_info_type='MX Social Security Reporting' ;
173:
174: ld_def_date date ;
175:

Line 1197: from pay_mx_legislation_info_f

1193: -- cursor to get the minimum wage for Zone A
1194: cursor c_minimum_wage_zonea (cp_effective_date in date )
1195: is
1196: select legislation_info2
1197: from pay_mx_legislation_info_f
1198: where legislation_info_type='MX Minimum Wage Information'
1199: and legislation_info1='MWA'
1200: and cp_effective_date between effective_start_date and effective_end_date ;
1201: