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 202: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,

198: 'Overtime and Holidays Worked' should be taken as weekly limit.
199: *****************************************************************************/
200:
201: TYPE g_leg_record IS RECORD (
202: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,
203: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
204: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
205: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
206: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,

Line 203: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,

199: *****************************************************************************/
200:
201: TYPE g_leg_record IS RECORD (
202: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,
203: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
204: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
205: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
206: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
207: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,

Line 204: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,

200:
201: TYPE g_leg_record IS RECORD (
202: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,
203: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
204: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
205: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
206: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
207: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
208: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,

Line 205: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,

201: TYPE g_leg_record IS RECORD (
202: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,
203: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
204: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
205: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
206: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
207: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
208: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
209: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,

Line 206: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,

202: effective_start_date pay_mx_legislation_info_f.effective_start_date%TYPE,
203: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
204: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
205: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
206: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
207: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
208: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
209: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
210: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,

Line 207: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,

203: effective_end_date pay_mx_legislation_info_f.effective_end_date%TYPE,
204: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
205: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
206: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
207: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
208: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
209: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
210: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
211: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);

Line 208: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,

204: jurisdiction_code pay_mx_legislation_info_f.jurisdiction_code%TYPE,
205: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
206: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
207: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
208: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
209: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
210: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
211: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);
212:

Line 209: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,

205: legislation_info_type pay_mx_legislation_info_f.legislation_info_type%TYPE,
206: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
207: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
208: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
209: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
210: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
211: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);
212:
213: TYPE g_isr_balances_rec IS RECORD (

Line 210: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,

206: legislation_info1 pay_mx_legislation_info_f.legislation_info1%TYPE,
207: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
208: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
209: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
210: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
211: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);
212:
213: TYPE g_isr_balances_rec IS RECORD (
214: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,

Line 211: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);

207: legislation_info2 pay_mx_legislation_info_f.legislation_info2%TYPE,
208: legislation_info3 pay_mx_legislation_info_f.legislation_info3%TYPE,
209: legislation_info4 pay_mx_legislation_info_f.legislation_info4%TYPE,
210: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
211: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);
212:
213: TYPE g_isr_balances_rec IS RECORD (
214: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
215: earnings_amt NUMBER,

Line 224: g_pay_mx_legislation_info_f g_leg_table;

220:
221: g_proc_name VARCHAR2(50);
222: g_debug BOOLEAN;
223: g_isr_balances g_isr_balances_table;
224: g_pay_mx_legislation_info_f g_leg_table;
225:
226: g_ptu_process BOOLEAN; -- Bug:9753792
227:
228: /****************************************************************************

Line 324: FROM pay_mx_legislation_info_f plif,

320: AND paf.effective_end_date >= g_ptu_start_date;
321:
322: CURSOR csr_get_min_wage (p_gre_id NUMBER, p_effective_date DATE) IS
323: SELECT fnd_number.canonical_to_number(plif.legislation_info2)
324: FROM pay_mx_legislation_info_f plif,
325: hr_organization_units hou,
326: hr_organization_information hoi
327: WHERE hou.organization_id = hoi.organization_id
328: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'

Line 1540: FROM pay_mx_legislation_info_f

1536: legislation_info3,
1537: legislation_info4,
1538: legislation_info5,
1539: legislation_info6
1540: FROM pay_mx_legislation_info_f
1541: WHERE legislation_info_type = p_legislation_info_type
1542: AND DECODE(p_legislation_info1,
1543: '$Sys_Def$', legislation_info1,
1544: p_legislation_info1) = legislation_info1

Line 1555: lv_jurisdiction pay_mx_legislation_info_f.jurisdiction_code%type;

1551: l_exists BOOLEAN;
1552: cntr NUMBER;
1553: ld_start_date DATE;
1554: ld_end_date DATE;
1555: lv_jurisdiction pay_mx_legislation_info_f.jurisdiction_code%type;
1556: lv_legislation_info_type pay_mx_legislation_info_f.legislation_info_type%type;
1557: BEGIN
1558: l_proc_name := g_proc_name ||'GET_MX_TAX_INFO';
1559: hr_utility_trace('Entering '||l_proc_name);

Line 1556: lv_legislation_info_type pay_mx_legislation_info_f.legislation_info_type%type;

1552: cntr NUMBER;
1553: ld_start_date DATE;
1554: ld_end_date DATE;
1555: lv_jurisdiction pay_mx_legislation_info_f.jurisdiction_code%type;
1556: lv_legislation_info_type pay_mx_legislation_info_f.legislation_info_type%type;
1557: BEGIN
1558: l_proc_name := g_proc_name ||'GET_MX_TAX_INFO';
1559: hr_utility_trace('Entering '||l_proc_name);
1560: l_exists := FALSE;

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

1557: BEGIN
1558: l_proc_name := g_proc_name ||'GET_MX_TAX_INFO';
1559: hr_utility_trace('Entering '||l_proc_name);
1560: l_exists := FALSE;
1561: cntr := g_pay_mx_legislation_info_f.count();
1562: hr_utility_trace('Number of cached legislative tax info records = '||cntr);
1563:
1564: IF cntr > 0 THEN /* Check if legislation info exists in cache. */
1565: FOR cntr IN g_pay_mx_legislation_info_f.first()..g_pay_mx_legislation_info_f.last()

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

1561: cntr := g_pay_mx_legislation_info_f.count();
1562: hr_utility_trace('Number of cached legislative tax info records = '||cntr);
1563:
1564: IF cntr > 0 THEN /* Check if legislation info exists in cache. */
1565: FOR cntr IN g_pay_mx_legislation_info_f.first()..g_pay_mx_legislation_info_f.last()
1566: LOOP
1567: IF g_pay_mx_legislation_info_f(cntr).legislation_info_type
1568: = p_legislation_info_type AND
1569: NVL(g_pay_mx_legislation_info_f(cntr).jurisdiction_code,

Line 1567: IF g_pay_mx_legislation_info_f(cntr).legislation_info_type

1563:
1564: IF cntr > 0 THEN /* Check if legislation info exists in cache. */
1565: FOR cntr IN g_pay_mx_legislation_info_f.first()..g_pay_mx_legislation_info_f.last()
1566: LOOP
1567: IF g_pay_mx_legislation_info_f(cntr).legislation_info_type
1568: = p_legislation_info_type AND
1569: NVL(g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1570: p_ctx_jurisdiction_code)= p_ctx_jurisdiction_code AND
1571: (p_legislation_info1 = '$Sys_Def$' OR

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

1565: FOR cntr IN g_pay_mx_legislation_info_f.first()..g_pay_mx_legislation_info_f.last()
1566: LOOP
1567: IF g_pay_mx_legislation_info_f(cntr).legislation_info_type
1568: = p_legislation_info_type AND
1569: NVL(g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1570: p_ctx_jurisdiction_code)= p_ctx_jurisdiction_code AND
1571: (p_legislation_info1 = '$Sys_Def$' OR
1572: g_pay_mx_legislation_info_f(cntr).legislation_info1
1573: = p_legislation_info1) AND

Line 1572: g_pay_mx_legislation_info_f(cntr).legislation_info1

1568: = p_legislation_info_type AND
1569: NVL(g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1570: p_ctx_jurisdiction_code)= p_ctx_jurisdiction_code AND
1571: (p_legislation_info1 = '$Sys_Def$' OR
1572: g_pay_mx_legislation_info_f(cntr).legislation_info1
1573: = p_legislation_info1) AND
1574: p_ctx_effective_date BETWEEN
1575: g_pay_mx_legislation_info_f(cntr).effective_start_date AND
1576: g_pay_mx_legislation_info_f(cntr).effective_end_date

Line 1575: g_pay_mx_legislation_info_f(cntr).effective_start_date AND

1571: (p_legislation_info1 = '$Sys_Def$' OR
1572: g_pay_mx_legislation_info_f(cntr).legislation_info1
1573: = p_legislation_info1) AND
1574: p_ctx_effective_date BETWEEN
1575: g_pay_mx_legislation_info_f(cntr).effective_start_date AND
1576: g_pay_mx_legislation_info_f(cntr).effective_end_date
1577:
1578: THEN
1579:

Line 1576: g_pay_mx_legislation_info_f(cntr).effective_end_date

1572: g_pay_mx_legislation_info_f(cntr).legislation_info1
1573: = p_legislation_info1) AND
1574: p_ctx_effective_date BETWEEN
1575: g_pay_mx_legislation_info_f(cntr).effective_start_date AND
1576: g_pay_mx_legislation_info_f(cntr).effective_end_date
1577:
1578: THEN
1579:
1580: l_exists := TRUE;

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

1579:
1580: l_exists := TRUE;
1581: hr_utility_trace ('Retrieving legislative tax info from cache.');
1582: /* Copy cache onto out parameters */
1583: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1584: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1585: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1586: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1587: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;

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

1580: l_exists := TRUE;
1581: hr_utility_trace ('Retrieving legislative tax info from cache.');
1582: /* Copy cache onto out parameters */
1583: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1584: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1585: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1586: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1587: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1588: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;

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

1581: hr_utility_trace ('Retrieving legislative tax info from cache.');
1582: /* Copy cache onto out parameters */
1583: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1584: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1585: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1586: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1587: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1588: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1589:

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

1582: /* Copy cache onto out parameters */
1583: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1584: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1585: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1586: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1587: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1588: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1589:
1590: EXIT;

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

1583: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1584: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1585: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1586: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1587: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1588: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1589:
1590: EXIT;
1591: END IF;

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

1584: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1585: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1586: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1587: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1588: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1589:
1590: EXIT;
1591: END IF;
1592: END LOOP;

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

1593: END IF;
1594:
1595: IF cntr = 0 OR (NOT l_exists) THEN
1596: IF cntr > 0 THEN
1597: cntr := g_pay_mx_legislation_info_f.last() + 1;
1598: ELSE
1599: cntr := 1;
1600: END IF;
1601: hr_utility_trace ('Legislative tax info not found in cache. Hitting database now.');

Line 1605: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,

1601: hr_utility_trace ('Legislative tax info not found in cache. Hitting database now.');
1602:
1603: OPEN csr_get_ss_info;
1604: FETCH csr_get_ss_info
1605: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,
1606: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1607: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1608: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1609: g_pay_mx_legislation_info_f(cntr).legislation_info1,

Line 1606: g_pay_mx_legislation_info_f(cntr).effective_end_date,

1602:
1603: OPEN csr_get_ss_info;
1604: FETCH csr_get_ss_info
1605: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,
1606: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1607: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1608: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1609: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1610: g_pay_mx_legislation_info_f(cntr).legislation_info2,

Line 1607: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,

1603: OPEN csr_get_ss_info;
1604: FETCH csr_get_ss_info
1605: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,
1606: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1607: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1608: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1609: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1610: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1611: g_pay_mx_legislation_info_f(cntr).legislation_info3,

Line 1608: g_pay_mx_legislation_info_f(cntr).legislation_info_type,

1604: FETCH csr_get_ss_info
1605: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,
1606: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1607: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1608: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1609: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1610: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1611: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1612: g_pay_mx_legislation_info_f(cntr).legislation_info4,

Line 1609: g_pay_mx_legislation_info_f(cntr).legislation_info1,

1605: INTO g_pay_mx_legislation_info_f(cntr).effective_start_date,
1606: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1607: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1608: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1609: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1610: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1611: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1612: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1613: g_pay_mx_legislation_info_f(cntr).legislation_info5,

Line 1610: g_pay_mx_legislation_info_f(cntr).legislation_info2,

1606: g_pay_mx_legislation_info_f(cntr).effective_end_date,
1607: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1608: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1609: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1610: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1611: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1612: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1613: g_pay_mx_legislation_info_f(cntr).legislation_info5,
1614: g_pay_mx_legislation_info_f(cntr).legislation_info6;

Line 1611: g_pay_mx_legislation_info_f(cntr).legislation_info3,

1607: g_pay_mx_legislation_info_f(cntr).jurisdiction_code,
1608: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1609: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1610: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1611: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1612: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1613: g_pay_mx_legislation_info_f(cntr).legislation_info5,
1614: g_pay_mx_legislation_info_f(cntr).legislation_info6;
1615: CLOSE csr_get_ss_info;

Line 1612: g_pay_mx_legislation_info_f(cntr).legislation_info4,

1608: g_pay_mx_legislation_info_f(cntr).legislation_info_type,
1609: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1610: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1611: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1612: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1613: g_pay_mx_legislation_info_f(cntr).legislation_info5,
1614: g_pay_mx_legislation_info_f(cntr).legislation_info6;
1615: CLOSE csr_get_ss_info;
1616:

Line 1613: g_pay_mx_legislation_info_f(cntr).legislation_info5,

1609: g_pay_mx_legislation_info_f(cntr).legislation_info1,
1610: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1611: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1612: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1613: g_pay_mx_legislation_info_f(cntr).legislation_info5,
1614: g_pay_mx_legislation_info_f(cntr).legislation_info6;
1615: CLOSE csr_get_ss_info;
1616:
1617: /* Override values fetched by this cursor

Line 1614: g_pay_mx_legislation_info_f(cntr).legislation_info6;

1610: g_pay_mx_legislation_info_f(cntr).legislation_info2,
1611: g_pay_mx_legislation_info_f(cntr).legislation_info3,
1612: g_pay_mx_legislation_info_f(cntr).legislation_info4,
1613: g_pay_mx_legislation_info_f(cntr).legislation_info5,
1614: g_pay_mx_legislation_info_f(cntr).legislation_info6;
1615: CLOSE csr_get_ss_info;
1616:
1617: /* Override values fetched by this cursor
1618: IF p_legislation_info_type = 'MX Social Security Information' THEN

Line 1620: g_pay_mx_legislation_info_f(cntr).legislation_info5 :=

1616:
1617: /* Override values fetched by this cursor
1618: IF p_legislation_info_type = 'MX Social Security Information' THEN
1619: IF p_legislation_info1 = 'WRI' THEN
1620: g_pay_mx_legislation_info_f(cntr).legislation_info5 :=
1621: hr_mx_utility.get_wrip (
1622: p_business_group_id => p_ctx_business_group_id,
1623: p_tax_unit_id => p_ctx_tax_unit_id);
1624: END IF;

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

1624: END IF;
1625: END IF;*/
1626:
1627: /* Copy cache onto out parameters */
1628: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1629: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1630: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1631: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1632: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;

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

1625: END IF;*/
1626:
1627: /* Copy cache onto out parameters */
1628: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1629: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1630: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1631: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1632: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1633: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;

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

1626:
1627: /* Copy cache onto out parameters */
1628: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1629: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1630: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1631: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1632: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1633: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1634: END IF;

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

1627: /* Copy cache onto out parameters */
1628: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1629: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1630: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1631: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1632: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1633: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1634: END IF;
1635:

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

1628: p_legislation_info1 := g_pay_mx_legislation_info_f(cntr).legislation_info1;
1629: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1630: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1631: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1632: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1633: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1634: END IF;
1635:
1636: -- Bug 4656174

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

1629: p_legislation_info2 := g_pay_mx_legislation_info_f(cntr).legislation_info2;
1630: p_legislation_info3 := g_pay_mx_legislation_info_f(cntr).legislation_info3;
1631: p_legislation_info4 := g_pay_mx_legislation_info_f(cntr).legislation_info4;
1632: p_legislation_info5 := g_pay_mx_legislation_info_f(cntr).legislation_info5;
1633: p_legislation_info6 := g_pay_mx_legislation_info_f(cntr).legislation_info6;
1634: END IF;
1635:
1636: -- Bug 4656174
1637: IF p_legislation_info_type = 'MX Social Security Information' THEN

Line 1671: g_pay_mx_legislation_info_f.DELETE();

1667:
1668: hr_utility_trace('Leaving '||l_proc_name);
1669: RETURN(0);
1670: EXCEPTION WHEN OTHERS THEN
1671: g_pay_mx_legislation_info_f.DELETE();
1672: RAISE;
1673: END GET_MX_TAX_INFO;
1674:
1675: /****************************************************************************

Line 1740: pay_mx_legislation_info_f pml

1736: SELECT DECODE(pml.legislation_info1,
1737: 'RANGE', org_information5,
1738: 'FLAT_RATE', org_information3)
1739: FROM hr_organization_information hoi,
1740: pay_mx_legislation_info_f pml
1741: WHERE hoi.organization_id = cp_legal_er_id
1742: AND hoi.org_information_context = 'MX_STATE_TAX_RULES'
1743: AND hoi.org_information1 = p_ctx_jurisdiction_code
1744: AND pml.jurisdiction_code = hoi.org_information1

Line 4211: SELECT legislation_info2 FROM PAY_MX_LEGISLATION_INFO_F WHERE

4207: ) RETURN varchar2 AS
4208:
4209: CURSOR get_min_wage
4210: IS
4211: SELECT legislation_info2 FROM PAY_MX_LEGISLATION_INFO_F WHERE
4212: legislation_info1=
4213: DECODE(P_ECON_ZONE,'NONE','GMW','MW'||P_ECON_ZONE) AND
4214: legislation_info_type = 'MX Minimum Wage Information'
4215: AND P_CTX_DATE_EARNED BETWEEN effective_start_date AND effective_end_date;