eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_MX_LEGISLATION_INFO_F

Line 157: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,

153:
154: *****************************************************************************/
155:
156: TYPE g_leg_record IS RECORD (
157: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,
158: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
159: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
160: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
161: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,

Line 158: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,

154: *****************************************************************************/
155:
156: TYPE g_leg_record IS RECORD (
157: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,
158: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
159: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
160: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
161: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
162: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,

Line 159: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,

155:
156: TYPE g_leg_record IS RECORD (
157: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,
158: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
159: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
160: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
161: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
162: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
163: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,

Line 160: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,

156: TYPE g_leg_record IS RECORD (
157: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,
158: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
159: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
160: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
161: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
162: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
163: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
164: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,

Line 161: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,

157: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,
158: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
159: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
160: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
161: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
162: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
163: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
164: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
165: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,

Line 162: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,

158: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
159: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
160: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
161: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
162: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
163: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
164: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
165: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
166: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);

Line 163: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,

159: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
160: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
161: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
162: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
163: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
164: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
165: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
166: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);
167:

Line 164: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,

160: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
161: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
162: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
163: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
164: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
165: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
166: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);
167:
168: TYPE g_isr_balances_rec IS RECORD (

Line 165: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,

161: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
162: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
163: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
164: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
165: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
166: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);
167:
168: TYPE g_isr_balances_rec IS RECORD (
169: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,

Line 166: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);

162: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
163: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
164: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
165: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
166: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);
167:
168: TYPE g_isr_balances_rec IS RECORD (
169: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
170: earnings_amt NUMBER,

Line 179: g_pay_mx_legislation_info_f g_leg_table;

175:
176: g_proc_name VARCHAR2(50);
177: g_debug BOOLEAN;
178: g_isr_balances g_isr_balances_table;
179: g_pay_mx_legislation_info_f g_leg_table;
180:
181:
182: /****************************************************************************
183: Name : HR_UTILITY_TRACE

Line 263: FROM pay_mx_legislation_info_f plif,

259: AND paf.effective_end_date;
260:
261: CURSOR csr_get_min_wage (p_gre_id NUMBER, p_effective_date DATE) IS
262: SELECT fnd_number.canonical_to_number(plif.legislation_info2)
263: FROM pay_mx_legislation_info_f plif,
264: hr_organization_units hou,
265: hr_organization_information hoi
266: WHERE hou.organization_id = hoi.organization_id
267: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'

Line 1406: FROM pay_mx_legislation_info_f

1402: legislation_info3,
1403: legislation_info4,
1404: legislation_info5,
1405: legislation_info6
1406: FROM pay_mx_legislation_info_f
1407: WHERE legislation_info_type = p_legislation_info_type
1408: AND DECODE(p_legislation_info1,
1409: '$Sys_Def$', legislation_info1,
1410: p_legislation_info1) = legislation_info1

Line 1421: lv_jurisdiction pay_mx_legislation_info_f.jurisdiction_code%type;

1417: l_exists BOOLEAN;
1418: cntr NUMBER;
1419: ld_start_date DATE;
1420: ld_end_date DATE;
1421: lv_jurisdiction pay_mx_legislation_info_f.jurisdiction_code%type;
1422: lv_legislation_info_type pay_mx_legislation_info_f.legislation_info_type%type;
1423: BEGIN
1424: l_proc_name := g_proc_name ||'GET_MX_TAX_INFO';
1425: hr_utility_trace('Entering '||l_proc_name);

Line 1422: lv_legislation_info_type pay_mx_legislation_info_f.legislation_info_type%type;

1418: cntr NUMBER;
1419: ld_start_date DATE;
1420: ld_end_date DATE;
1421: lv_jurisdiction pay_mx_legislation_info_f.jurisdiction_code%type;
1422: lv_legislation_info_type pay_mx_legislation_info_f.legislation_info_type%type;
1423: BEGIN
1424: l_proc_name := g_proc_name ||'GET_MX_TAX_INFO';
1425: hr_utility_trace('Entering '||l_proc_name);
1426: l_exists := FALSE;

Line 1427: cntr := g_pay_mx_legislation_info_f.count();

1423: BEGIN
1424: l_proc_name := g_proc_name ||'GET_MX_TAX_INFO';
1425: hr_utility_trace('Entering '||l_proc_name);
1426: l_exists := FALSE;
1427: cntr := g_pay_mx_legislation_info_f.count();
1428: hr_utility_trace('Number of cached legislative tax info records = '||cntr);
1429:
1430: IF cntr > 0 THEN /* Check if legislation info exists in cache. */
1431: FOR cntr IN g_pay_mx_legislation_info_f.first()..g_pay_mx_legislation_info_f.last()

Line 1431: FOR cntr IN g_pay_mx_legislation_info_f.first()..g_pay_mx_legislation_info_f.last()

1427: cntr := g_pay_mx_legislation_info_f.count();
1428: hr_utility_trace('Number of cached legislative tax info records = '||cntr);
1429:
1430: IF cntr > 0 THEN /* Check if legislation info exists in cache. */
1431: FOR cntr IN g_pay_mx_legislation_info_f.first()..g_pay_mx_legislation_info_f.last()
1432: LOOP
1433: IF g_pay_mx_legislation_info_f(cntr).legislation_info_type
1434: = p_legislation_info_type AND
1435: NVL(g_pay_mx_legislation_info_f(cntr).jurisdiction_code,

Line 1433: IF g_pay_mx_legislation_info_f(cntr).legislation_info_type

1429:
1430: IF cntr > 0 THEN /* Check if legislation info exists in cache. */
1431: FOR cntr IN g_pay_mx_legislation_info_f.first()..g_pay_mx_legislation_info_f.last()
1432: LOOP
1433: IF g_pay_mx_legislation_info_f(cntr).legislation_info_type
1434: = p_legislation_info_type AND
1435: NVL(g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1436: p_ctx_jurisdiction_code)= p_ctx_jurisdiction_code AND
1437: (p_legislation_info1 = '$Sys_Def$' OR

Line 1435: NVL(g_pay_mx_legislation_info_f(cntr).jurisdiction_code,

1431: FOR cntr IN g_pay_mx_legislation_info_f.first()..g_pay_mx_legislation_info_f.last()
1432: LOOP
1433: IF g_pay_mx_legislation_info_f(cntr).legislation_info_type
1434: = p_legislation_info_type AND
1435: NVL(g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1436: p_ctx_jurisdiction_code)= p_ctx_jurisdiction_code AND
1437: (p_legislation_info1 = '$Sys_Def$' OR
1438: g_pay_mx_legislation_info_f(cntr).legislation_info1
1439: = p_legislation_info1) AND

Line 1438: g_pay_mx_legislation_info_f(cntr).legislation_info1

1434: = p_legislation_info_type AND
1435: NVL(g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1436: p_ctx_jurisdiction_code)= p_ctx_jurisdiction_code AND
1437: (p_legislation_info1 = '$Sys_Def$' OR
1438: g_pay_mx_legislation_info_f(cntr).legislation_info1
1439: = p_legislation_info1) AND
1440: p_ctx_effective_date BETWEEN
1441: g_pay_mx_legislation_info_f(cntr).effective_start_date AND
1442: g_pay_mx_legislation_info_f(cntr).effective_end_date

Line 1441: g_pay_mx_legislation_info_f(cntr).effective_start_date AND

1437: (p_legislation_info1 = '$Sys_Def$' OR
1438: g_pay_mx_legislation_info_f(cntr).legislation_info1
1439: = p_legislation_info1) AND
1440: p_ctx_effective_date BETWEEN
1441: g_pay_mx_legislation_info_f(cntr).effective_start_date AND
1442: g_pay_mx_legislation_info_f(cntr).effective_end_date
1443:
1444: THEN
1445:

Line 1442: g_pay_mx_legislation_info_f(cntr).effective_end_date

1438: g_pay_mx_legislation_info_f(cntr).legislation_info1
1439: = p_legislation_info1) AND
1440: p_ctx_effective_date BETWEEN
1441: g_pay_mx_legislation_info_f(cntr).effective_start_date AND
1442: g_pay_mx_legislation_info_f(cntr).effective_end_date
1443:
1444: THEN
1445:
1446: l_exists := TRUE;

Line 1449: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;

1445:
1446: l_exists := TRUE;
1447: hr_utility_trace ('Retrieving legislative tax info from cache.');
1448: /* Copy cache onto out parameters */
1449: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1450: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1451: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1452: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1453: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;

Line 1450: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;

1446: l_exists := TRUE;
1447: hr_utility_trace ('Retrieving legislative tax info from cache.');
1448: /* Copy cache onto out parameters */
1449: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1450: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1451: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1452: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1453: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1454: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;

Line 1451: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;

1447: hr_utility_trace ('Retrieving legislative tax info from cache.');
1448: /* Copy cache onto out parameters */
1449: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1450: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1451: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1452: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1453: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1454: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1455:

Line 1452: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;

1448: /* Copy cache onto out parameters */
1449: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1450: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1451: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1452: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1453: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1454: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1455:
1456: EXIT;

Line 1453: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;

1449: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1450: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1451: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1452: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1453: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1454: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1455:
1456: EXIT;
1457: END IF;

Line 1454: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;

1450: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1451: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1452: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1453: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1454: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1455:
1456: EXIT;
1457: END IF;
1458: END LOOP;

Line 1463: cntr := g_pay_mx_legislation_info_f.last() + 1;

1459: END IF;
1460:
1461: IF cntr = 0 OR (NOT l_exists) THEN
1462: IF cntr > 0 THEN
1463: cntr := g_pay_mx_legislation_info_f.last() + 1;
1464: ELSE
1465: cntr := 1;
1466: END IF;
1467: hr_utility_trace ('Legislative tax info not found in cache. Hitting database now.');

Line 1471: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,

1467: hr_utility_trace ('Legislative tax info not found in cache. Hitting database now.');
1468:
1469: OPEN csr_get_ss_info;
1470: FETCH csr_get_ss_info
1471: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,
1472: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1473: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1474: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1475: g_pay_mx_legislation_info_f(cntr).legislation_info1,

Line 1472: g_pay_mx_legislation_info_f(cntr).effective_end_date,

1468:
1469: OPEN csr_get_ss_info;
1470: FETCH csr_get_ss_info
1471: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,
1472: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1473: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1474: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1475: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1476: g_pay_mx_legislation_info_f(cntr).legislation_info2,

Line 1473: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,

1469: OPEN csr_get_ss_info;
1470: FETCH csr_get_ss_info
1471: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,
1472: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1473: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1474: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1475: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1476: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1477: g_pay_mx_legislation_info_f(cntr).legislation_info3,

Line 1474: g_pay_mx_legislation_info_f(cntr).legislation_info_type,

1470: FETCH csr_get_ss_info
1471: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,
1472: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1473: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1474: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1475: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1476: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1477: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1478: g_pay_mx_legislation_info_f(cntr).legislation_info4,

Line 1475: g_pay_mx_legislation_info_f(cntr).legislation_info1,

1471: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,
1472: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1473: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1474: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1475: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1476: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1477: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1478: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1479: g_pay_mx_legislation_info_f(cntr).legislation_info5,

Line 1476: g_pay_mx_legislation_info_f(cntr).legislation_info2,

1472: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1473: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1474: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1475: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1476: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1477: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1478: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1479: g_pay_mx_legislation_info_f(cntr).legislation_info5,
1480: g_pay_mx_legislation_info_f(cntr).legislation_info6;

Line 1477: g_pay_mx_legislation_info_f(cntr).legislation_info3,

1473: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1474: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1475: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1476: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1477: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1478: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1479: g_pay_mx_legislation_info_f(cntr).legislation_info5,
1480: g_pay_mx_legislation_info_f(cntr).legislation_info6;
1481: CLOSE csr_get_ss_info;

Line 1478: g_pay_mx_legislation_info_f(cntr).legislation_info4,

1474: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1475: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1476: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1477: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1478: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1479: g_pay_mx_legislation_info_f(cntr).legislation_info5,
1480: g_pay_mx_legislation_info_f(cntr).legislation_info6;
1481: CLOSE csr_get_ss_info;
1482:

Line 1479: g_pay_mx_legislation_info_f(cntr).legislation_info5,

1475: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1476: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1477: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1478: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1479: g_pay_mx_legislation_info_f(cntr).legislation_info5,
1480: g_pay_mx_legislation_info_f(cntr).legislation_info6;
1481: CLOSE csr_get_ss_info;
1482:
1483: /* Override values fetched by this cursor

Line 1480: g_pay_mx_legislation_info_f(cntr).legislation_info6;

1476: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1477: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1478: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1479: g_pay_mx_legislation_info_f(cntr).legislation_info5,
1480: g_pay_mx_legislation_info_f(cntr).legislation_info6;
1481: CLOSE csr_get_ss_info;
1482:
1483: /* Override values fetched by this cursor
1484: IF p_legislation_info_type = 'MX Social Security Information' THEN

Line 1486: g_pay_mx_legislation_info_f(cntr).legislation_info5 :=

1482:
1483: /* Override values fetched by this cursor
1484: IF p_legislation_info_type = 'MX Social Security Information' THEN
1485: IF p_legislation_info1 = 'WRI' THEN
1486: g_pay_mx_legislation_info_f(cntr).legislation_info5 :=
1487: hr_mx_utility.get_wrip (
1488: p_business_group_id => p_ctx_business_group_id,
1489: p_tax_unit_id => p_ctx_tax_unit_id);
1490: END IF;

Line 1494: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;

1490: END IF;
1491: END IF;*/
1492:
1493: /* Copy cache onto out parameters */
1494: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1495: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1496: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1497: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1498: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;

Line 1495: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;

1491: END IF;*/
1492:
1493: /* Copy cache onto out parameters */
1494: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1495: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1496: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1497: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1498: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1499: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;

Line 1496: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;

1492:
1493: /* Copy cache onto out parameters */
1494: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1495: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1496: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1497: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1498: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1499: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1500: END IF;

Line 1497: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;

1493: /* Copy cache onto out parameters */
1494: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1495: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1496: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1497: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1498: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1499: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1500: END IF;
1501:

Line 1498: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;

1494: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1495: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1496: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1497: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1498: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1499: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1500: END IF;
1501:
1502: -- Bug 4656174

Line 1499: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;

1495: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1496: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1497: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1498: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1499: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1500: END IF;
1501:
1502: -- Bug 4656174
1503: IF p_legislation_info_type = 'MX Social Security Information' THEN

Line 1537: g_pay_mx_legislation_info_f.DELETE();

1533:
1534: hr_utility_trace('Leaving '||l_proc_name);
1535: RETURN(0);
1536: EXCEPTION WHEN OTHERS THEN
1537: g_pay_mx_legislation_info_f.DELETE();
1538: RAISE;
1539: END GET_MX_TAX_INFO;
1540:
1541: /****************************************************************************

Line 1606: pay_mx_legislation_info_f pml

1602: SELECT DECODE(pml.legislation_info1,
1603: 'RANGE', org_information5,
1604: 'FLAT_RATE', org_information3)
1605: FROM hr_organization_information hoi,
1606: pay_mx_legislation_info_f pml
1607: WHERE hoi.organization_id = cp_legal_er_id
1608: AND hoi.org_information_context = 'MX_STATE_TAX_RULES'
1609: AND hoi.org_information1 = p_ctx_jurisdiction_code
1610: AND pml.jurisdiction_code = hoi.org_information1

Line 2913: SELECT legislation_info2 FROM PAY_MX_LEGISLATION_INFO_F WHERE

2909: ) RETURN varchar2 AS
2910:
2911: CURSOR get_min_wage
2912: IS
2913: SELECT legislation_info2 FROM PAY_MX_LEGISLATION_INFO_F WHERE
2914: legislation_info1=
2915: DECODE(P_ECON_ZONE,'NONE','GMW','MW'||P_ECON_ZONE) AND
2916: legislation_info_type = 'MX Minimum Wage Information'
2917: AND P_CTX_DATE_EARNED BETWEEN effective_start_date AND effective_end_date;