APPS.PAY_IE_NES_REPORT_PKG dependencies on PAY_BALANCE_PKG

Line 1704: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1700: hr_utility.set_location(' Inside balance Loop ', 850);
1701: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1702: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
1703:
1704: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1705: l_ness_assignment_action_ytd,
1706: g_employer_id,
1707: null,
1708: null,

Line 1719: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1715: hr_utility.set_location(' Inside balance Loop ', 850);
1716: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1717: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
1718:
1719: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1720: l_ness_assignment_action_ytd,
1721: g_employer_id,
1722: null,
1723: null,

Line 1734: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1730: hr_utility.set_location(' Inside balance Loop ', 850);
1731: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1732: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
1733:
1734: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1735: l_ness_assignment_action_ytd,
1736: g_employer_id,
1737: null,
1738: null,

Line 1749: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1745: hr_utility.set_location(' Inside balance Loop ', 850);
1746: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1747: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
1748:
1749: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1750: l_ness_assignment_action,
1751: g_employer_id,
1752: null,
1753: null,

Line 1825: l_chrs_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1821: Raise l_nes_exception;
1822: END IF;
1823: */
1824: ELSE
1825: l_chrs_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1826: l_ness_assignment_action,
1827: g_employer_id,
1828: null,
1829: null,

Line 1845: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1841: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
1842:
1843: l_mat_bal_val := nvl(l_mat_bal_val,0)
1844: +
1845: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1846: l_ness_assignment_action_ytd,
1847: g_employer_id,
1848: null,
1849: null,

Line 1866: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1862:
1863: l_sic_bal_val :=
1864: nvl(l_sic_bal_val,0)
1865: +
1866: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1867: l_ness_assignment_action_ytd,
1868: g_employer_id,
1869: null,
1870: null,

Line 1886: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1882:
1883: l_otl_bal_val :=
1884: NVl(l_otl_bal_val,0)
1885: +
1886: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1887: l_ness_assignment_action_ytd,
1888: g_employer_id,
1889: null,
1890: null,

Line 1909: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1905:
1906: l_mat_bal_val :=
1907: nvl(l_mat_bal_val,0)
1908: +
1909: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1910: l_ness_assignment_action_ytd,
1911: g_employer_id,
1912: null,
1913: null,

Line 1930: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1926:
1927: l_sic_bal_val :=
1928: nvl(l_sic_bal_val,0)
1929: +
1930: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1931: l_ness_assignment_action_ytd,
1932: g_employer_id,
1933: null,
1934: null,

Line 1949: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1945:
1946: l_otl_bal_val :=
1947: nvl(l_otl_bal_val,0)
1948: +
1949: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1950: l_ness_assignment_action_ytd,
1951: g_employer_id,
1952: null,
1953: null,

Line 1969: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1965: hr_utility.set_location(' Inside balance Loop ', 850);
1966: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1967: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
1968:
1969: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1970: l_ness_assignment_action_ytd,
1971: g_employer_id,
1972: null,
1973: null,

Line 1984: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1980: hr_utility.set_location(' Inside balance Loop ', 850);
1981: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1982: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
1983:
1984: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1985: l_ness_assignment_action_ytd,
1986: g_employer_id,
1987: null,
1988: null,

Line 1999: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

1995: hr_utility.set_location(' Inside balance Loop ', 850);
1996: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1997: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
1998:
1999: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2000: l_ness_assignment_action_ytd,
2001: g_employer_id,
2002: null,
2003: null,

Line 2014: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2010: hr_utility.set_location(' Inside balance Loop ', 850);
2011: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2012: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
2013:
2014: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2015: l_ness_assignment_action_ytd,
2016: g_employer_id,
2017: null,
2018: null,

Line 2032: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2028: hr_utility.set_location(' Inside balance Loop ', 850);
2029: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2030: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
2031:
2032: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2033: l_ness_assignment_action_ytd,
2034: g_employer_id,
2035: null,
2036: null,

Line 2054: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2050:
2051: l_total_weeks :=
2052: nvl(l_total_weeks,0)
2053: +
2054: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2055: l_ness_assignment_action_ytd,
2056: g_employer_id,
2057: null,
2058: null,

Line 2072: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2068:
2069: l_total_weeks :=
2070: nvl(l_total_weeks,0)
2071: +
2072: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2073: l_ness_assignment_action_ytd,
2074: g_employer_id,
2075: null,
2076: null,

Line 2090: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2086:
2087: l_total_weeks :=
2088: nvl(l_total_weeks,0)
2089: +
2090: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2091: l_ness_assignment_action_ytd,
2092: g_employer_id,
2093: null,
2094: null,

Line 2105: l_regwg_bal_val_ptd := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2101: hr_utility.set_location(' Inside balance Loop ', 850);
2102: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2103: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
2104:
2105: l_regwg_bal_val_ptd := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2106: l_ness_assignment_action,
2107: g_employer_id,
2108: null,
2109: null,

Line 2121: l_ovrt_bal_val_ptd := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2117: hr_utility.set_location(' Inside balance Loop ', 850);
2118: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2119: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
2120:
2121: l_ovrt_bal_val_ptd := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2122: l_ness_assignment_action,
2123: g_employer_id,
2124: null,
2125: null,

Line 2136: l_reg_shft_allnce_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2132: hr_utility.set_location(' Inside balance Loop ', 850);
2133: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2134: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
2135:
2136: l_reg_shft_allnce_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2137: l_ness_assignment_action,
2138: g_employer_id,
2139: null,
2140: null,

Line 2151: l_ireg_shft_allnce_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2147: hr_utility.set_location(' Inside balance Loop ', 850);
2148: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2149: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
2150:
2151: l_ireg_shft_allnce_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2152: l_ness_assignment_action,
2153: g_employer_id,
2154: null,
2155: null,

Line 2169: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2165:
2166: l_holi_bal_val :=
2167: NVL(l_holi_bal_val,0)
2168: +
2169: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2170: l_ness_assignment_action_ytd,
2171: g_employer_id,
2172: null,
2173: null,

Line 2187: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2183:
2184: l_holi_bal_val :=
2185: NVL(l_holi_bal_val,0)
2186: +
2187: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2188: l_ness_assignment_action_ytd,
2189: g_employer_id,
2190: null,
2191: null,

Line 2202: l_tot_comm_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2198: hr_utility.set_location(' Inside balance Loop ', 850);
2199: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2200: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
2201:
2202: l_tot_comm_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2203: l_ness_assignment_action,
2204: g_employer_id,
2205: null,
2206: null,

Line 2220: l_regwg_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2216: hr_utility.set_location(' Inside balance Loop ', 850);
2217: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2218: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
2219:
2220: l_regwg_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2221: l_ness_assignment_action_ytd,
2222: g_employer_id,
2223: null,
2224: null,

Line 2235: l_irrb_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2231: hr_utility.set_location(' Inside balance Loop ', 850);
2232: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2233: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
2234:
2235: l_irrb_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2236: l_ness_assignment_action_ytd,
2237: g_employer_id,
2238: null,
2239: null,

Line 2250: l_ovrt_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2246: hr_utility.set_location(' Inside balance Loop ', 850);
2247: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2248: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
2249:
2250: l_ovrt_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2251: l_ness_assignment_action_ytd,
2252: g_employer_id,
2253: null,
2254: null,

Line 2265: l_othr_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2261: hr_utility.set_location(' Inside balance Loop ', 850);
2262: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2263: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
2264:
2265: l_othr_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2266: l_ness_assignment_action,
2267: g_employer_id,
2268: null,
2269: null,

Line 2286: l_chrs_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2282:
2283:
2284: IF(l_valid_asg_rec.hourly_or_salaried='H')
2285: THEN
2286: l_chrs_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2287: l_ness_assignment_action,
2288: g_employer_id,
2289: null,
2290: null,

Line 2306: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2302: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
2303:
2304: l_mat_bal_val_ppsn := nvl(l_mat_bal_val_ppsn,0)
2305: +
2306: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2307: l_ness_assignment_action_ytd,
2308: g_employer_id,
2309: null,
2310: null,

Line 2327: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2323:
2324: l_sic_bal_val_ppsn :=
2325: nvl(l_sic_bal_val_ppsn,0)
2326: +
2327: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2328: l_ness_assignment_action_ytd,
2329: g_employer_id,
2330: null,
2331: null,

Line 2347: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2343:
2344: l_otl_bal_val_ppsn :=
2345: NVl(l_otl_bal_val_ppsn,0)
2346: +
2347: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2348: l_ness_assignment_action_ytd,
2349: g_employer_id,
2350: null,
2351: null,

Line 2370: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2366:
2367: l_mat_bal_val_ppsn :=
2368: nvl(l_mat_bal_val_ppsn,0)
2369: +
2370: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2371: l_ness_assignment_action_ytd,
2372: g_employer_id,
2373: null,
2374: null,

Line 2391: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2387:
2388: l_sic_bal_val_ppsn :=
2389: nvl(l_sic_bal_val_ppsn,0)
2390: +
2391: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2392: l_ness_assignment_action_ytd,
2393: g_employer_id,
2394: null,
2395: null,

Line 2410: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2406:
2407: l_otl_bal_val_ppsn :=
2408: nvl(l_otl_bal_val_ppsn,0)
2409: +
2410: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2411: l_ness_assignment_action_ytd,
2412: g_employer_id,
2413: null,
2414: null,

Line 2430: l_vhi_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2426: hr_utility.set_location(' Inside balance Loop ', 850);
2427: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2428: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
2429:
2430: l_vhi_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2431: l_ness_assignment_action_ytd,
2432: g_employer_id,
2433: null,
2434: null,

Line 2445: l_hse_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2441: hr_utility.set_location(' Inside balance Loop ', 850);
2442: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2443: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
2444:
2445: l_hse_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2446: l_ness_assignment_action_ytd,
2447: g_employer_id,
2448: null,
2449: null,

Line 2460: l_otben_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2456: hr_utility.set_location(' Inside balance Loop ', 850);
2457: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2458: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
2459:
2460: l_otben_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2461: l_ness_assignment_action_ytd,
2462: g_employer_id,
2463: null,
2464: null,

Line 2475: l_ot_sub_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2471: hr_utility.set_location(' Inside balance Loop ', 850);
2472: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2473: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
2474:
2475: l_ot_sub_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2476: l_ness_assignment_action_ytd,
2477: g_employer_id,
2478: null,
2479: null,

Line 2493: l_bik_veh_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2489: hr_utility.set_location(' Inside balance Loop ', 850);
2490: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2491: hr_utility.set_location(' l_ness_assignment_action_ytd '|| l_ness_assignment_action_ytd, 850);
2492:
2493: l_bik_veh_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2494: l_ness_assignment_action_ytd,
2495: g_employer_id,
2496: null,
2497: null,

Line 2515: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2511:
2512: l_total_weeks_ppsn :=
2513: nvl(l_total_weeks_ppsn,0)
2514: +
2515: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2516: l_ness_assignment_action_ytd,
2517: g_employer_id,
2518: null,
2519: null,

Line 2533: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2529:
2530: l_total_weeks_ppsn :=
2531: nvl(l_total_weeks_ppsn,0)
2532: +
2533: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2534: l_ness_assignment_action_ytd,
2535: g_employer_id,
2536: null,
2537: null,

Line 2551: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2547:
2548: l_total_weeks_ppsn :=
2549: nvl(l_total_weeks_ppsn,0)
2550: +
2551: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2552: l_ness_assignment_action_ytd,
2553: g_employer_id,
2554: null,
2555: null,

Line 2566: l_regwg_bal_val_ptd_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2562: hr_utility.set_location(' Inside balance Loop ', 850);
2563: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2564: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
2565:
2566: l_regwg_bal_val_ptd_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2567: l_ness_assignment_action,
2568: g_employer_id,
2569: null,
2570: null,

Line 2582: l_ovrt_bal_val_ptd_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2578: hr_utility.set_location(' Inside balance Loop ', 850);
2579: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2580: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
2581:
2582: l_ovrt_bal_val_ptd_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2583: l_ness_assignment_action,
2584: g_employer_id,
2585: null,
2586: null,

Line 2597: l_reg_shft_allnce_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2593: hr_utility.set_location(' Inside balance Loop ', 850);
2594: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2595: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
2596:
2597: l_reg_shft_allnce_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2598: l_ness_assignment_action,
2599: g_employer_id,
2600: null,
2601: null,

Line 2612: l_ireg_shft_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2608: hr_utility.set_location(' Inside balance Loop ', 850);
2609: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2610: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
2611:
2612: l_ireg_shft_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2613: l_ness_assignment_action,
2614: g_employer_id,
2615: null,
2616: null,

Line 2630: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2626:
2627: l_holi_bal_val_ppsn :=
2628: NVL(l_holi_bal_val_ppsn,0)
2629: +
2630: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2631: l_ness_assignment_action_ytd,
2632: g_employer_id,
2633: null,
2634: null,

Line 2648: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2644:
2645: l_holi_bal_val_ppsn :=
2646: NVL(l_holi_bal_val_ppsn,0)
2647: +
2648: NVL(PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2649: l_ness_assignment_action_ytd,
2650: g_employer_id,
2651: null,
2652: null,

Line 2663: l_tot_comm_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,

2659: hr_utility.set_location(' Inside balance Loop ', 850);
2660: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
2661: hr_utility.set_location(' l_ness_assignment_action '||l_ness_assignment_action, 850);
2662:
2663: l_tot_comm_bal_val_ppsn := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
2664: l_ness_assignment_action,
2665: g_employer_id,
2666: null,
2667: null,