APPS.PAY_MX_UTILITY dependencies on PAY_MX_LEGISLATION_INFO_F

Line 213: pay_mx_legislation_info_f pmli

209:
210: CURSOR c_period_type IS
211: SELECT period_type, legislation_info2
212: FROM per_time_period_types ptpt,
213: pay_mx_legislation_info_f pmli
214: WHERE legislation_info_type = 'MX Annualization Factor'
215: AND instr(period_type,legislation_info1) > 0;
216:
217: CURSOR c_pay_prd_type(cp_payroll_id NUMBER) IS

Line 964: FROM pay_mx_legislation_info_f

960: RETURN VARCHAR2 IS
961:
962: CURSOR c_get_def_imp_date IS
963: SELECT fnd_date.canonical_to_date(legislation_info1)
964: FROM pay_mx_legislation_info_f
965: WHERE legislation_info_type = 'MX Social Security Reporting' ;
966:
967: ld_def_date date ;
968:

Line 1173: SELECT fnd_number.canonical_to_number(legislation_info2) FROM PAY_MX_LEGISLATION_INFO_F WHERE

1169: ) RETURN varchar2 AS
1170:
1171: CURSOR get_min_wage
1172: IS
1173: SELECT fnd_number.canonical_to_number(legislation_info2) FROM PAY_MX_LEGISLATION_INFO_F WHERE
1174: legislation_info1=
1175: DECODE(P_ECON_ZONE,'NONE','GMW','MW'||P_ECON_ZONE) AND
1176: legislation_info_type = 'MX Minimum Wage Information'
1177: AND P_CTX_DATE_EARNED BETWEEN effective_start_date AND effective_end_date;