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 1426: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN

1422: --
1423: */
1424: -------------------------------------------------------------------------
1425: -- IF l_ni_a_total <> 0 THEN
1426: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN
1427: l_ni_a_total := report_balance_items
1428: (p_balance_name => G_NI_A_TOTAL,
1429: p_assignment_action_id => p_assignment_action_id);
1430: l_ni_a_able_balance := report_balance_items

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

1438: p_assignment_action_id => p_assignment_action_id);
1439: END IF;
1440: --
1441: -- IF l_ni_b_total <> 0 THEN
1442: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'B') = 1 THEN
1443: l_ni_b_total := report_balance_items
1444: (p_balance_name => G_NI_B_TOTAL,
1445: p_assignment_action_id => p_assignment_action_id);
1446: l_ni_b_able_balance := report_balance_items

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

1454: p_assignment_action_id => p_assignment_action_id);
1455: END IF;
1456: --
1457: -- IF l_ni_d_total <> 0 THEN
1458: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'D') = 1 THEN
1459: l_ni_d_total := report_balance_items
1460: (p_balance_name => G_NI_D_TOTAL,
1461: p_assignment_action_id => p_assignment_action_id);
1462: l_ni_d_able_balance := report_balance_items

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

1470: p_assignment_action_id => p_assignment_action_id);
1471: END IF;
1472: --
1473: -- IF l_ni_e_total <> 0 THEN
1474: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'E') = 1 THEN
1475: l_ni_e_total := report_balance_items
1476: (p_balance_name => G_NI_E_TOTAL,
1477: p_assignment_action_id => p_assignment_action_id);
1478: l_ni_e_able_balance := report_balance_items

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

1486: p_assignment_action_id => p_assignment_action_id);
1487: END IF;
1488: --
1489: -- IF l_ni_f_total <> 0 THEN
1490: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'F') = 1 THEN
1491: l_ni_f_total := report_balance_items
1492: (p_balance_name => G_NI_f_TOTAL,
1493: p_assignment_action_id => p_assignment_action_id);
1494: l_ni_f_able_balance := report_balance_items

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

1502: p_assignment_action_id => p_assignment_action_id);
1503: END IF;
1504: --
1505: -- IF l_ni_g_total <> 0 THEN
1506: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'G') = 1 THEN
1507: l_ni_g_total := report_balance_items
1508: (p_balance_name => G_NI_G_TOTAL,
1509: p_assignment_action_id => p_assignment_action_id);
1510: l_ni_g_able_balance := report_balance_items

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

1517: (p_balance_name => G_NI_G_EMPLOYEE_BALANCE,
1518: p_assignment_action_id => p_assignment_action_id);
1519: END IF;
1520: --
1521: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'J') = 1 THEN
1522: l_ni_j_total := report_balance_items
1523: (p_balance_name => G_NI_J_TOTAL,
1524: p_assignment_action_id => p_assignment_action_id);
1525: l_ni_j_able_balance := report_balance_items

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

1532: (p_balance_name => G_NI_J_EMPLOYEE_BALANCE,
1533: p_assignment_action_id => p_assignment_action_id);
1534: END IF;
1535: --
1536: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'L') = 1 THEN
1537: l_ni_l_total := report_balance_items
1538: (p_balance_name => G_NI_L_TOTAL,
1539: p_assignment_action_id => p_assignment_action_id);
1540: l_ni_l_able_balance := report_balance_items

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

1547: (p_balance_name => G_NI_L_EMPLOYEE_BALANCE,
1548: p_assignment_action_id => p_assignment_action_id);
1549: END IF;
1550: --
1551: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'S') = 1 THEN
1552: l_ni_s_total := report_balance_items
1553: (p_balance_name => G_NI_S_TOTAL,
1554: p_assignment_action_id => p_assignment_action_id);
1555: l_ni_s_able_balance := report_balance_items

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

1657: l_L_balance := replace(p_balance_name,'NI ','NI L ');
1658: l_S_balance := replace(p_balance_name,'NI ','NI S ');
1659:
1660: -- if g_ni_a_total_value <> 0
1661: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 then
1662: l_total := report_balance_items(p_balance_name => l_A_balance,
1663: p_dimension => p_dimension,
1664: p_assignment_action_id => p_assignment_action_id);
1665:

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

1667: end if;
1668:
1669:
1670: --if g_ni_b_total_value <> 0
1671: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'B') = 1 then
1672: l_total := report_balance_items(p_balance_name => l_B_balance,
1673: p_dimension => p_dimension,
1674: p_assignment_action_id => p_assignment_action_id);
1675:

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

1677: end if;
1678:
1679:
1680: -- if g_ni_d_total_value <> 0
1681: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'D') = 1 then
1682: l_total := report_balance_items(p_balance_name => l_D_balance,
1683: p_dimension => p_dimension,
1684: p_assignment_action_id => p_assignment_action_id);
1685:

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

1686: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1687: end if;
1688:
1689: -- if g_ni_e_total_value <> 0
1690: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'E') = 1 then
1691: l_total := report_balance_items(p_balance_name => l_E_balance,
1692: p_dimension => p_dimension,
1693: p_assignment_action_id => p_assignment_action_id);
1694:

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

1695: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1696: end if;
1697:
1698: -- if g_ni_f_total_value <> 0
1699: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'F') = 1 then
1700: l_total := report_balance_items(p_balance_name => l_F_balance,
1701: p_dimension => p_dimension,
1702: p_assignment_action_id => p_assignment_action_id);
1703:

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

1704: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1705: end if;
1706:
1707: -- if g_ni_g_total_value <> 0
1708: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'G') = 1 then
1709: l_total := report_balance_items(p_balance_name => l_G_balance,
1710: p_dimension => p_dimension,
1711: p_assignment_action_id => p_assignment_action_id);
1712:

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

1712:
1713: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1714: end if;
1715:
1716: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'J') = 1 then
1717: l_total := report_balance_items(p_balance_name => l_J_balance,
1718: p_dimension => p_dimension,
1719: p_assignment_action_id => p_assignment_action_id);
1720:

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

1720:
1721: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1722: end if;
1723:
1724: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'L') = 1 then
1725: l_total := report_balance_items(p_balance_name => l_L_balance,
1726: p_dimension => p_dimension,
1727: p_assignment_action_id => p_assignment_action_id);
1728:

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

1728:
1729: l_all_cat_total := l_all_cat_total + nvl(l_total,0);
1730: end if;
1731:
1732: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'S') = 1 then
1733: l_total := report_balance_items(p_balance_name => l_S_balance,
1734: p_dimension => p_dimension,
1735: p_assignment_action_id => p_assignment_action_id);
1736:

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

2003: --
2004: -- establish the total NI balance for each category. This is done now to
2005: -- cut down on processing when individual NI balances are retrieved later.
2006: --
2007: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN
2008: g_ni_a_total_value := report_balance_items
2009: (p_balance_name => g_ni_a_total_type,
2010: p_dimension => g_tax_district_ytd,
2011: p_assignment_action_id => p_assignment_action_id);

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

2009: (p_balance_name => g_ni_a_total_type,
2010: p_dimension => g_tax_district_ytd,
2011: p_assignment_action_id => p_assignment_action_id);
2012: end if;
2013: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'B') = 1 THEN
2014: g_ni_b_total_value := report_balance_items
2015: (p_balance_name => g_ni_b_total_type,
2016: p_dimension => g_tax_district_ytd,
2017: p_assignment_action_id => p_assignment_action_id);

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

2016: p_dimension => g_tax_district_ytd,
2017: p_assignment_action_id => p_assignment_action_id);
2018: end if;
2019:
2020: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'D') = 1 THEN
2021: g_ni_d_total_value := report_balance_items
2022: (p_balance_name => g_ni_d_total_type,
2023: p_dimension => g_tax_district_ytd,
2024: p_assignment_action_id => p_assignment_action_id);

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

2023: p_dimension => g_tax_district_ytd,
2024: p_assignment_action_id => p_assignment_action_id);
2025: end if;
2026:
2027: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'E') = 1 THEN
2028: g_ni_e_total_value := report_balance_items
2029: (p_balance_name => g_ni_e_total_type,
2030: p_dimension => g_tax_district_ytd,
2031: p_assignment_action_id => p_assignment_action_id);

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

2030: p_dimension => g_tax_district_ytd,
2031: p_assignment_action_id => p_assignment_action_id);
2032: end if;
2033:
2034: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'F') = 1 THEN
2035: g_ni_f_total_value := report_balance_items
2036: (p_balance_name => g_ni_f_total_type,
2037: p_dimension => g_tax_district_ytd,
2038: p_assignment_action_id => p_assignment_action_id);

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

2037: p_dimension => g_tax_district_ytd,
2038: p_assignment_action_id => p_assignment_action_id);
2039: end if;
2040:
2041: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'G') = 1 THEN
2042: g_ni_g_total_value := report_balance_items
2043: (p_balance_name => g_ni_g_total_type,
2044: p_dimension => g_tax_district_ytd,
2045: p_assignment_action_id => p_assignment_action_id);

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

2044: p_dimension => g_tax_district_ytd,
2045: p_assignment_action_id => p_assignment_action_id);
2046: end if;
2047:
2048: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'J') = 1 THEN
2049: g_ni_j_total_value := report_balance_items
2050: (p_balance_name => g_ni_j_total_type,
2051: p_dimension => g_tax_district_ytd,
2052: p_assignment_action_id => p_assignment_action_id);

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

2051: p_dimension => g_tax_district_ytd,
2052: p_assignment_action_id => p_assignment_action_id);
2053: end if;
2054:
2055: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'L') = 1 THEN
2056: g_ni_l_total_value := report_balance_items
2057: (p_balance_name => g_ni_l_total_type,
2058: p_dimension => g_tax_district_ytd,
2059: p_assignment_action_id => p_assignment_action_id);

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

2058: p_dimension => g_tax_district_ytd,
2059: p_assignment_action_id => p_assignment_action_id);
2060: end if;
2061:
2062: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'S') = 1 THEN
2063: g_ni_s_total_value := report_balance_items
2064: (p_balance_name => g_ni_s_total_type,
2065: p_dimension => g_tax_district_ytd,
2066: p_assignment_action_id => p_assignment_action_id);

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

2437: --
2438: -- establish the total NI balance for each category. This is done now to
2439: -- cut down on processing when individual NI balances are retrieved later.
2440: --
2441: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN
2442: g_ni_a_total_value := report_balance_items
2443: (p_balance_name => g_ni_a_total_type,
2444: p_dimension => g_tax_district_ytd,
2445: p_assignment_action_id => p_assignment_action_id);

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

2443: (p_balance_name => g_ni_a_total_type,
2444: p_dimension => g_tax_district_ytd,
2445: p_assignment_action_id => p_assignment_action_id);
2446: end if;
2447: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'B') = 1 THEN
2448: g_ni_b_total_value := report_balance_items
2449: (p_balance_name => g_ni_b_total_type,
2450: p_dimension => g_tax_district_ytd,
2451: p_assignment_action_id => p_assignment_action_id);

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

2450: p_dimension => g_tax_district_ytd,
2451: p_assignment_action_id => p_assignment_action_id);
2452: end if;
2453:
2454: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'D') = 1 THEN
2455: g_ni_d_total_value := report_balance_items
2456: (p_balance_name => g_ni_d_total_type,
2457: p_dimension => g_tax_district_ytd,
2458: p_assignment_action_id => p_assignment_action_id);

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

2457: p_dimension => g_tax_district_ytd,
2458: p_assignment_action_id => p_assignment_action_id);
2459: end if;
2460:
2461: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'E') = 1 THEN
2462: g_ni_e_total_value := report_balance_items
2463: (p_balance_name => g_ni_e_total_type,
2464: p_dimension => g_tax_district_ytd,
2465: p_assignment_action_id => p_assignment_action_id);

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

2464: p_dimension => g_tax_district_ytd,
2465: p_assignment_action_id => p_assignment_action_id);
2466: end if;
2467:
2468: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'F') = 1 THEN
2469: g_ni_f_total_value := report_balance_items
2470: (p_balance_name => g_ni_f_total_type,
2471: p_dimension => g_tax_district_ytd,
2472: p_assignment_action_id => p_assignment_action_id);

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

2471: p_dimension => g_tax_district_ytd,
2472: p_assignment_action_id => p_assignment_action_id);
2473: end if;
2474:
2475: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'G') = 1 THEN
2476: g_ni_g_total_value := report_balance_items
2477: (p_balance_name => g_ni_g_total_type,
2478: p_dimension => g_tax_district_ytd,
2479: p_assignment_action_id => p_assignment_action_id);

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

2478: p_dimension => g_tax_district_ytd,
2479: p_assignment_action_id => p_assignment_action_id);
2480: end if;
2481:
2482: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'J') = 1 THEN
2483: g_ni_j_total_value := report_balance_items
2484: (p_balance_name => g_ni_j_total_type,
2485: p_dimension => g_tax_district_ytd,
2486: p_assignment_action_id => p_assignment_action_id);

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

2485: p_dimension => g_tax_district_ytd,
2486: p_assignment_action_id => p_assignment_action_id);
2487: end if;
2488:
2489: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'L') = 1 THEN
2490: g_ni_l_total_value := report_balance_items
2491: (p_balance_name => g_ni_l_total_type,
2492: p_dimension => g_tax_district_ytd,
2493: p_assignment_action_id => p_assignment_action_id);

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

2492: p_dimension => g_tax_district_ytd,
2493: p_assignment_action_id => p_assignment_action_id);
2494: end if;
2495:
2496: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'S') = 1 THEN
2497: g_ni_s_total_value := report_balance_items
2498: (p_balance_name => g_ni_s_total_type,
2499: p_dimension => g_tax_district_ytd,
2500: p_assignment_action_id => p_assignment_action_id);

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

2756: pay_action_interlocks loc
2757: where loc.locked_action_id = aa.assignment_action_id
2758: and loc.locking_action_id = paa.assignment_action_id);
2759:
2760: -- Copied from HR_GBBAL.get_latest_action_id, include action type P and U
2761: cursor csr_formula_2 is
2762: SELECT /*+ USE_NL(paa, ppa) */
2763: --fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) /*Bug 4775025*/
2764: to_number(substr(max(to_char(ppa.effective_date,'J')||lpad(paa.assignment_action_id,15,'0')),8))