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_GB_PAYROLL_ACTIONS_PKG dependencies on HR_GBBAL

Line 1409: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN

1405: --
1406: */
1407: -------------------------------------------------------------------------
1408: -- IF l_ni_a_total <> 0 THEN
1409: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN
1410: l_ni_a_total := report_balance_items
1411: (p_balance_name => G_NI_A_TOTAL,
1412: p_assignment_action_id => p_assignment_action_id);
1413: l_ni_a_able_balance := report_balance_items

Line 1425: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'B') = 1 THEN

1421: p_assignment_action_id => p_assignment_action_id);
1422: END IF;
1423: --
1424: -- IF l_ni_b_total <> 0 THEN
1425: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'B') = 1 THEN
1426: l_ni_b_total := report_balance_items
1427: (p_balance_name => G_NI_B_TOTAL,
1428: p_assignment_action_id => p_assignment_action_id);
1429: l_ni_b_able_balance := report_balance_items

Line 1441: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'D') = 1 THEN

1437: p_assignment_action_id => p_assignment_action_id);
1438: END IF;
1439: --
1440: -- IF l_ni_d_total <> 0 THEN
1441: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'D') = 1 THEN
1442: l_ni_d_total := report_balance_items
1443: (p_balance_name => G_NI_D_TOTAL,
1444: p_assignment_action_id => p_assignment_action_id);
1445: l_ni_d_able_balance := report_balance_items

Line 1457: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'E') = 1 THEN

1453: p_assignment_action_id => p_assignment_action_id);
1454: END IF;
1455: --
1456: -- IF l_ni_e_total <> 0 THEN
1457: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'E') = 1 THEN
1458: l_ni_e_total := report_balance_items
1459: (p_balance_name => G_NI_E_TOTAL,
1460: p_assignment_action_id => p_assignment_action_id);
1461: l_ni_e_able_balance := report_balance_items

Line 1473: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'F') = 1 THEN

1469: p_assignment_action_id => p_assignment_action_id);
1470: END IF;
1471: --
1472: -- IF l_ni_f_total <> 0 THEN
1473: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'F') = 1 THEN
1474: l_ni_f_total := report_balance_items
1475: (p_balance_name => G_NI_f_TOTAL,
1476: p_assignment_action_id => p_assignment_action_id);
1477: l_ni_f_able_balance := report_balance_items

Line 1489: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'G') = 1 THEN

1485: p_assignment_action_id => p_assignment_action_id);
1486: END IF;
1487: --
1488: -- IF l_ni_g_total <> 0 THEN
1489: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'G') = 1 THEN
1490: l_ni_g_total := report_balance_items
1491: (p_balance_name => G_NI_G_TOTAL,
1492: p_assignment_action_id => p_assignment_action_id);
1493: l_ni_g_able_balance := report_balance_items

Line 1504: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'J') = 1 THEN

1500: (p_balance_name => G_NI_G_EMPLOYEE_BALANCE,
1501: p_assignment_action_id => p_assignment_action_id);
1502: END IF;
1503: --
1504: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'J') = 1 THEN
1505: l_ni_j_total := report_balance_items
1506: (p_balance_name => G_NI_J_TOTAL,
1507: p_assignment_action_id => p_assignment_action_id);
1508: l_ni_j_able_balance := report_balance_items

Line 1519: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'L') = 1 THEN

1515: (p_balance_name => G_NI_J_EMPLOYEE_BALANCE,
1516: p_assignment_action_id => p_assignment_action_id);
1517: END IF;
1518: --
1519: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'L') = 1 THEN
1520: l_ni_l_total := report_balance_items
1521: (p_balance_name => G_NI_L_TOTAL,
1522: p_assignment_action_id => p_assignment_action_id);
1523: l_ni_l_able_balance := report_balance_items

Line 1534: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'S') = 1 THEN

1530: (p_balance_name => G_NI_L_EMPLOYEE_BALANCE,
1531: p_assignment_action_id => p_assignment_action_id);
1532: END IF;
1533: --
1534: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'S') = 1 THEN
1535: l_ni_s_total := report_balance_items
1536: (p_balance_name => G_NI_S_TOTAL,
1537: p_assignment_action_id => p_assignment_action_id);
1538: l_ni_s_able_balance := report_balance_items

Line 1641: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 then

1637: l_L_balance := replace(p_balance_name,'NI ','NI L ');
1638: l_S_balance := replace(p_balance_name,'NI ','NI S ');
1639:
1640: -- if g_ni_a_total_value <> 0
1641: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 then
1642: l_total := report_balance_items(p_balance_name => l_A_balance,
1643: p_dimension => p_dimension,
1644: p_assignment_action_id => p_assignment_action_id);
1645:

Line 1651: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'B') = 1 then

1647: end if;
1648:
1649:
1650: --if g_ni_b_total_value <> 0
1651: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'B') = 1 then
1652: l_total := report_balance_items(p_balance_name => l_B_balance,
1653: p_dimension => p_dimension,
1654: p_assignment_action_id => p_assignment_action_id);
1655:

Line 1661: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'D') = 1 then

1657: end if;
1658:
1659:
1660: -- if g_ni_d_total_value <> 0
1661: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'D') = 1 then
1662: l_total := report_balance_items(p_balance_name => l_D_balance,
1663: p_dimension => p_dimension,
1664: p_assignment_action_id => p_assignment_action_id);
1665:

Line 1670: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'E') = 1 then

1666: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1667: end if;
1668:
1669: -- if g_ni_e_total_value <> 0
1670: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'E') = 1 then
1671: l_total := report_balance_items(p_balance_name => l_E_balance,
1672: p_dimension => p_dimension,
1673: p_assignment_action_id => p_assignment_action_id);
1674:

Line 1679: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'F') = 1 then

1675: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1676: end if;
1677:
1678: -- if g_ni_f_total_value <> 0
1679: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'F') = 1 then
1680: l_total := report_balance_items(p_balance_name => l_F_balance,
1681: p_dimension => p_dimension,
1682: p_assignment_action_id => p_assignment_action_id);
1683:

Line 1688: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'G') = 1 then

1684: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1685: end if;
1686:
1687: -- if g_ni_g_total_value <> 0
1688: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'G') = 1 then
1689: l_total := report_balance_items(p_balance_name => l_G_balance,
1690: p_dimension => p_dimension,
1691: p_assignment_action_id => p_assignment_action_id);
1692:

Line 1696: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'J') = 1 then

1692:
1693: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1694: end if;
1695:
1696: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'J') = 1 then
1697: l_total := report_balance_items(p_balance_name => l_J_balance,
1698: p_dimension => p_dimension,
1699: p_assignment_action_id => p_assignment_action_id);
1700:

Line 1704: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'L') = 1 then

1700:
1701: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1702: end if;
1703:
1704: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'L') = 1 then
1705: l_total := report_balance_items(p_balance_name => l_L_balance,
1706: p_dimension => p_dimension,
1707: p_assignment_action_id => p_assignment_action_id);
1708:

Line 1712: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'S') = 1 then

1708:
1709: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1710: end if;
1711:
1712: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'S') = 1 then
1713: l_total := report_balance_items(p_balance_name => l_S_balance,
1714: p_dimension => p_dimension,
1715: p_assignment_action_id => p_assignment_action_id);
1716:

Line 1982: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN

1978: --
1979: -- establish the total NI balance for each category. This is done now to
1980: -- cut down on processing when individual NI balances are retrieved later.
1981: --
1982: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN
1983: g_ni_a_total_value := report_balance_items
1984: (p_balance_name => g_ni_a_total_type,
1985: p_dimension => g_tax_district_ytd,
1986: p_assignment_action_id => p_assignment_action_id);

Line 1988: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'B') = 1 THEN

1984: (p_balance_name => g_ni_a_total_type,
1985: p_dimension => g_tax_district_ytd,
1986: p_assignment_action_id => p_assignment_action_id);
1987: end if;
1988: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'B') = 1 THEN
1989: g_ni_b_total_value := report_balance_items
1990: (p_balance_name => g_ni_b_total_type,
1991: p_dimension => g_tax_district_ytd,
1992: p_assignment_action_id => p_assignment_action_id);

Line 1995: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'D') = 1 THEN

1991: p_dimension => g_tax_district_ytd,
1992: p_assignment_action_id => p_assignment_action_id);
1993: end if;
1994:
1995: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'D') = 1 THEN
1996: g_ni_d_total_value := report_balance_items
1997: (p_balance_name => g_ni_d_total_type,
1998: p_dimension => g_tax_district_ytd,
1999: p_assignment_action_id => p_assignment_action_id);

Line 2002: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'E') = 1 THEN

1998: p_dimension => g_tax_district_ytd,
1999: p_assignment_action_id => p_assignment_action_id);
2000: end if;
2001:
2002: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'E') = 1 THEN
2003: g_ni_e_total_value := report_balance_items
2004: (p_balance_name => g_ni_e_total_type,
2005: p_dimension => g_tax_district_ytd,
2006: p_assignment_action_id => p_assignment_action_id);

Line 2009: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'F') = 1 THEN

2005: p_dimension => g_tax_district_ytd,
2006: p_assignment_action_id => p_assignment_action_id);
2007: end if;
2008:
2009: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'F') = 1 THEN
2010: g_ni_f_total_value := report_balance_items
2011: (p_balance_name => g_ni_f_total_type,
2012: p_dimension => g_tax_district_ytd,
2013: p_assignment_action_id => p_assignment_action_id);

Line 2016: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'G') = 1 THEN

2012: p_dimension => g_tax_district_ytd,
2013: p_assignment_action_id => p_assignment_action_id);
2014: end if;
2015:
2016: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'G') = 1 THEN
2017: g_ni_g_total_value := report_balance_items
2018: (p_balance_name => g_ni_g_total_type,
2019: p_dimension => g_tax_district_ytd,
2020: p_assignment_action_id => p_assignment_action_id);

Line 2023: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'J') = 1 THEN

2019: p_dimension => g_tax_district_ytd,
2020: p_assignment_action_id => p_assignment_action_id);
2021: end if;
2022:
2023: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'J') = 1 THEN
2024: g_ni_j_total_value := report_balance_items
2025: (p_balance_name => g_ni_j_total_type,
2026: p_dimension => g_tax_district_ytd,
2027: p_assignment_action_id => p_assignment_action_id);

Line 2030: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'L') = 1 THEN

2026: p_dimension => g_tax_district_ytd,
2027: p_assignment_action_id => p_assignment_action_id);
2028: end if;
2029:
2030: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'L') = 1 THEN
2031: g_ni_l_total_value := report_balance_items
2032: (p_balance_name => g_ni_l_total_type,
2033: p_dimension => g_tax_district_ytd,
2034: p_assignment_action_id => p_assignment_action_id);

Line 2037: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'S') = 1 THEN

2033: p_dimension => g_tax_district_ytd,
2034: p_assignment_action_id => p_assignment_action_id);
2035: end if;
2036:
2037: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'S') = 1 THEN
2038: g_ni_s_total_value := report_balance_items
2039: (p_balance_name => g_ni_s_total_type,
2040: p_dimension => g_tax_district_ytd,
2041: p_assignment_action_id => p_assignment_action_id);

Line 2359: -- Copied from HR_GBBAL.get_latest_action_id, include action type P and U

2355: pay_action_interlocks loc
2356: where loc.locked_action_id = aa.assignment_action_id
2357: and loc.locking_action_id = paa.assignment_action_id);
2358:
2359: -- Copied from HR_GBBAL.get_latest_action_id, include action type P and U
2360: cursor csr_formula_2 is
2361: SELECT /*+ USE_NL(paa, ppa) */
2362: --fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) /*Bug 4775025*/
2363: to_number(substr(max(to_char(ppa.effective_date,'J')||lpad(paa.assignment_action_id,15,'0')),8))