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_IE_P45_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 65: ** call to pay_balance_pkg.get_value to derive

61: ** instead to check presence of benefit amount.
62: ** 12-AUG-2003 npershad 3079945 Changed the cursor csr_iea_weeks
63: ** to derive correct insurable weeks at class A
64: ** 12-SEP-2003 npershad 3079945 Commented cusor crs_iea_weeks and added
65: ** call to pay_balance_pkg.get_value to derive
66: ** correct insurable weeks at class A in cursor
67: ** Cur_Act_Contexts
68: ** 07-APR-2004 ssekhar 3436737 Added code to support K and M Employee and
69: ** Employer figures when a severance payment

Line 1049: SELECT sum(PAY_BALANCE_PKG.GET_VALUE(l_defined_bal_id, -- changes made

1045: v_class varchar2(30);
1046:
1047:
1048: CURSOR Cur_Act_Contexts(l_defined_bal_id number,p_context_value varchar2) IS
1049: SELECT sum(PAY_BALANCE_PKG.GET_VALUE(l_defined_bal_id, -- changes made
1050: pac.ASSIGNMENT_ACTION_ID,
1051: g_paye_ref,
1052: null,
1053: pac.CONTEXT_ID,

Line 1451: if pay_balance_pkg.get_value(k_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and

1447: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1448: -- will have no child assignment actions. Call this only if child actions exists.
1449: hr_utility.set_location(' kal before if l_prsi_cat = ' || l_prsi_cat,40);
1450: IF pay_act_id IS NOT NULL THEN
1451: if pay_balance_pkg.get_value(k_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1452: l_prsi_cat is not NULL and l_prsi_count <> 2 then --Bug 4724788
1453: l_prsi_cat := l_prsi_cat ||', K';
1454: elsif pay_balance_pkg.get_value(k_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1455: l_prsi_cat is null then

Line 1454: elsif pay_balance_pkg.get_value(k_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and

1450: IF pay_act_id IS NOT NULL THEN
1451: if pay_balance_pkg.get_value(k_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1452: l_prsi_cat is not NULL and l_prsi_count <> 2 then --Bug 4724788
1453: l_prsi_cat := l_prsi_cat ||', K';
1454: elsif pay_balance_pkg.get_value(k_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1455: l_prsi_cat is null then
1456: l_prsi_cat := 'K';
1457: end if;
1458:

Line 1459: if pay_balance_pkg.get_value(m_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and

1455: l_prsi_cat is null then
1456: l_prsi_cat := 'K';
1457: end if;
1458:
1459: if pay_balance_pkg.get_value(m_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1460: l_prsi_cat is not NULL and l_prsi_count <> 2 then --Bug 4724788
1461: l_prsi_cat := l_prsi_cat ||', M';
1462: elsif pay_balance_pkg.get_value(m_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1463: l_prsi_cat is null then

Line 1462: elsif pay_balance_pkg.get_value(m_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and

1458:
1459: if pay_balance_pkg.get_value(m_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1460: l_prsi_cat is not NULL and l_prsi_count <> 2 then --Bug 4724788
1461: l_prsi_cat := l_prsi_cat ||', M';
1462: elsif pay_balance_pkg.get_value(m_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1463: l_prsi_cat is null then
1464: l_prsi_cat := 'M';
1465: end if;
1466: END IF;

Line 1658: SELECT sum(PAY_BALANCE_PKG.GET_VALUE(l_defined_bal_id, -- changes made

1654: --bug 5383808. IF previous P45 exists fetch the sum of PRSI insurable
1655: -- weeks for class between the current run action sequence locked by P45
1656: -- and run action locked by previous P45.
1657: CURSOR Cur_Act_Contexts(l_defined_bal_id number) IS
1658: SELECT sum(PAY_BALANCE_PKG.GET_VALUE(l_defined_bal_id, -- changes made
1659: pac.ASSIGNMENT_ACTION_ID,
1660: g_paye_ref,
1661: null,
1662: pac.CONTEXT_ID,

Line 1721: SELECT sum(PAY_BALANCE_PKG.GET_VALUE(l_defined_bal_id, -- changes made

1717: AND pai.action_information1 = p_defined_bal_id;
1718:
1719: /* 7291676 */
1720: CURSOR Cur_Act_Contexts_ppsn(l_defined_bal_id number,c_ppsn_override per_assignment_extra_info.aei_information1%type) IS
1721: SELECT sum(PAY_BALANCE_PKG.GET_VALUE(l_defined_bal_id, -- changes made
1722: pac.ASSIGNMENT_ACTION_ID,
1723: g_paye_ref,
1724: null,
1725: pac.CONTEXT_ID,

Line 1850: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

1846: /*OPEN Cur_Act_Contexts;
1847: FETCH Cur_Act_Contexts INTO v_Cur_Act_Contexts;
1848: IF Cur_Act_Contexts%FOUND
1849: THEN
1850: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1851: v_Cur_Act_Contexts.ASSIGNMENT_ACTION_ID,
1852: null,
1853: null,
1854: v_Cur_Act_Contexts.CONTEXT_ID,

Line 1882: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

1878:
1879:
1880: --Bug 3079945 End
1881: /*IF nvl(p_supp_flag,'N') = 'N' AND (p_last_p45_action IS NOT NULL) then
1882: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1883: p_last_p45_action,
1884: g_paye_ref,
1885: null,
1886: null,

Line 1902: /* l_balance_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

1898: l_balance_value := l_balance_value + l_pre_ins_bal;
1899: END IF;
1900: hr_utility.set_location('After IE PRSI_ClassA Insurable Weeks..'||l_pre_ins_bal,1000.1);
1901: ELSE
1902: /* l_balance_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1903: p_source_id );
1904: */
1905: --bug 5383808, call this only p_source_id is not null.
1906: if p_source_id is not null then

Line 1907: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

1903: p_source_id );
1904: */
1905: --bug 5383808, call this only p_source_id is not null.
1906: if p_source_id is not null then
1907: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1908: p_source_id,
1909: g_paye_ref,
1910: null,
1911: null,

Line 1927: l_gross_income_adj_value := PAY_BALANCE_PKG.GET_VALUE(l_gross_income_adj,

1923: IF csr_usc_defined_bal_id%NOTFOUND THEN
1924: l_gross_income_adj := 0;
1925: END IF;
1926: CLOSE csr_usc_defined_bal_id ;
1927: l_gross_income_adj_value := PAY_BALANCE_PKG.GET_VALUE(l_gross_income_adj,
1928: p_source_id,
1929: g_paye_ref,
1930: null,
1931: null,

Line 1941: l_court_order_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order,

1937: IF csr_usc_defined_bal_id%NOTFOUND THEN
1938: l_court_order := 0;
1939: END IF;
1940: CLOSE csr_usc_defined_bal_id ;
1941: l_court_order_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order,
1942: p_source_id,
1943: g_paye_ref,
1944: null,
1945: null,

Line 1955: l_court_order_child_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order_child,

1951: IF csr_usc_defined_bal_id%NOTFOUND THEN
1952: l_court_order_child := 0;
1953: END IF;
1954: CLOSE csr_usc_defined_bal_id ;
1955: l_court_order_child_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order_child,
1956: p_source_id,
1957: g_paye_ref,
1958: null,
1959: null,

Line 1969: l_bik_tax_prsi_pay_value := PAY_BALANCE_PKG.GET_VALUE(l_bik_tax_prsi_pay,

1965: IF csr_usc_defined_bal_id%NOTFOUND THEN
1966: l_bik_tax_prsi_pay := 0;
1967: END IF;
1968: CLOSE csr_usc_defined_bal_id ;
1969: l_bik_tax_prsi_pay_value := PAY_BALANCE_PKG.GET_VALUE(l_bik_tax_prsi_pay,
1970: p_source_id,
1971: g_paye_ref,
1972: null,
1973: null,

Line 1984: l_prsa_er_contr := PAY_BALANCE_PKG.GET_VALUE(l_prsa_er_contr_id,

1980: IF csr_usc_defined_bal_id%NOTFOUND THEN
1981: l_prsa_er_contr_id := 0;
1982: END IF;
1983: CLOSE csr_usc_defined_bal_id ;
1984: l_prsa_er_contr := PAY_BALANCE_PKG.GET_VALUE(l_prsa_er_contr_id,
1985: p_source_id,
1986: g_paye_ref,
1987: null,
1988: null,

Line 2004: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2000: hr_utility.set_location('sg Last P45 Action ='||p_last_p45_action,37);
2001:
2002: --bug 5383808
2003: IF (p_balance like 'IE Taxable Pay') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2004: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2005: p_prev_src_id,
2006: g_paye_ref,
2007: null,
2008: null,

Line 2029: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2025: END IF;
2026:
2027:
2028: IF (p_balance like 'IE P45 Pay') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2029: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2030: p_prev_src_id,
2031: g_paye_ref,
2032: null,
2033: null,

Line 2048: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2044: END IF;
2045: END IF;
2046:
2047: IF (p_balance like 'IE P45 Tax Deducted') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2048: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2049: p_prev_src_id,
2050: g_paye_ref,
2051: null,
2052: null,

Line 2067: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2063: END IF;
2064: END IF;
2065:
2066: IF (p_balance like 'IE Net Tax') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2067: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2068: p_prev_src_id,
2069: g_paye_ref,
2070: null,
2071: null,

Line 2086: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2082: END IF;
2083: END IF;
2084: -- 13359530 13513882
2085: IF (p_balance like 'IE USCable Pay') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2086: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2087: p_prev_src_id,
2088: g_paye_ref,
2089: null,
2090: null,

Line 2095: l_gross_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_gross_income_adj,

2091: null,
2092: null,
2093: null);
2094: -- bug 13513882
2095: l_gross_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_gross_income_adj,
2096: p_prev_src_id,
2097: g_paye_ref,
2098: null,
2099: null,

Line 2103: l_court_order_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order,

2099: null,
2100: null,
2101: null,
2102: null);
2103: l_court_order_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order,
2104: p_prev_src_id,
2105: g_paye_ref,
2106: null,
2107: null,

Line 2111: l_court_order_child_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order_child,

2107: null,
2108: null,
2109: null,
2110: null);
2111: l_court_order_child_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order_child,
2112: p_prev_src_id,
2113: g_paye_ref,
2114: null,
2115: null,

Line 2119: l_bik_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_bik_tax_prsi_pay,

2115: null,
2116: null,
2117: null,
2118: null);
2119: l_bik_bal_value := PAY_BALANCE_PKG.GET_VALUE(l_bik_tax_prsi_pay,
2120: p_prev_src_id,
2121: g_paye_ref,
2122: null,
2123: null,

Line 2128: l_prsa_er_contr := PAY_BALANCE_PKG.GET_VALUE(l_prsa_er_contr_id,

2124: null,
2125: null,
2126: null);
2127: --13013273
2128: l_prsa_er_contr := PAY_BALANCE_PKG.GET_VALUE(l_prsa_er_contr_id,
2129: p_prev_src_id,
2130: g_paye_ref,
2131: null,
2132: null,

Line 2151: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2147: l_balance_value := l_balance_value - l_p45_last_bal_value;
2148: END IF;
2149: END IF;
2150: IF (p_balance like 'IE USC Balance') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2151: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2152: p_prev_src_id,
2153: g_paye_ref,
2154: null,
2155: null,

Line 2169: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2165: l_balance_value := l_balance_value - l_p45_last_bal_value;
2166: END IF;
2167: END IF;
2168: IF (p_balance like 'IE P45 USC Pay') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2169: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2170: p_prev_src_id,
2171: g_paye_ref,
2172: null,
2173: null,

Line 2187: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2183: l_balance_value := l_balance_value - l_p45_last_bal_value;
2184: END IF;
2185: END IF;
2186: IF (p_balance like 'IE P45 USC Deducted') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2187: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2188: p_prev_src_id,
2189: g_paye_ref,
2190: null,
2191: null,

Line 2206: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2202: END IF;
2203: END IF;
2204: -- 13359530
2205: IF (p_balance like 'IE PRSI Insurable Weeks') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2206: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2207: p_prev_src_id,
2208: g_paye_ref,
2209: null,
2210: null,

Line 2226: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2222: END IF;
2223:
2224: -- changes made for PRSI bug 5510536. To show this employment figures only.
2225: IF (p_balance like 'IE PRSI Employer') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2226: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2227: p_prev_src_id,
2228: g_paye_ref,
2229: null,
2230: null,

Line 2245: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2241: END IF;
2242: END IF;
2243:
2244: IF (p_balance like 'IE PRSI K Employer Lump Sum') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2245: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2246: p_prev_src_id,
2247: g_paye_ref,
2248: null,
2249: null,

Line 2264: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2260: END IF;
2261: END IF;
2262:
2263: IF (p_balance like 'IE PRSI M Employer Lump Sum') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2264: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2265: p_prev_src_id,
2266: g_paye_ref,
2267: null,
2268: null,

Line 2283: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2279: END IF;
2280: END IF;
2281:
2282: IF (p_balance like 'IE PRSI Employee') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2283: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2284: p_prev_src_id,
2285: g_paye_ref,
2286: null,
2287: null,

Line 2302: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2298: END IF;
2299: END IF;
2300:
2301: IF (p_balance like 'IE PRSI K Employee Lump Sum') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2302: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2303: p_prev_src_id,
2304: g_paye_ref,
2305: null,
2306: null,

Line 2321: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,

2317: END IF;
2318: END IF;
2319:
2320: IF (p_balance like 'IE PRSI M Employee Lump Sum') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
2321: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
2322: p_prev_src_id,
2323: g_paye_ref,
2324: null,
2325: null,

Line 2488: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(p_ytd_def_bal_id,

2484: ELSE
2485: OPEN get_last_source_id;
2486: FETCH get_last_source_id into l_prev_source_id;
2487: CLOSE get_last_source_id;
2488: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(p_ytd_def_bal_id,
2489: l_prev_source_id,
2490: g_paye_ref,
2491: null,
2492: null,

Line 2506: l_gross_income_adj_value := PAY_BALANCE_PKG.GET_VALUE(l_gross_income_adj,

2502: IF csr_usc_defined_bal_id%NOTFOUND THEN
2503: l_gross_income_adj := 0;
2504: END IF;
2505: CLOSE csr_usc_defined_bal_id ;
2506: l_gross_income_adj_value := PAY_BALANCE_PKG.GET_VALUE(l_gross_income_adj,
2507: l_prev_source_id,
2508: g_paye_ref,
2509: null,
2510: null,

Line 2520: l_court_order_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order,

2516: IF csr_usc_defined_bal_id%NOTFOUND THEN
2517: l_court_order := 0;
2518: END IF;
2519: CLOSE csr_usc_defined_bal_id ;
2520: l_court_order_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order,
2521: l_prev_source_id,
2522: g_paye_ref,
2523: null,
2524: null,

Line 2534: l_court_order_child_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order_child,

2530: IF csr_usc_defined_bal_id%NOTFOUND THEN
2531: l_court_order_child := 0;
2532: END IF;
2533: CLOSE csr_usc_defined_bal_id ;
2534: l_court_order_child_value := PAY_BALANCE_PKG.GET_VALUE(l_court_order_child,
2535: l_prev_source_id,
2536: g_paye_ref,
2537: null,
2538: null,

Line 2548: l_bik_tax_prsi_pay_value := PAY_BALANCE_PKG.GET_VALUE(l_bik_tax_prsi_pay,

2544: IF csr_usc_defined_bal_id%NOTFOUND THEN
2545: l_bik_tax_prsi_pay := 0;
2546: END IF;
2547: CLOSE csr_usc_defined_bal_id ;
2548: l_bik_tax_prsi_pay_value := PAY_BALANCE_PKG.GET_VALUE(l_bik_tax_prsi_pay,
2549: l_prev_source_id,
2550: g_paye_ref,
2551: null,
2552: null,

Line 2563: l_prsa_er_contr := PAY_BALANCE_PKG.GET_VALUE(l_prsa_er_contr_id,

2559: IF csr_usc_defined_bal_id%NOTFOUND THEN
2560: l_prsa_er_contr_id := 0;
2561: END IF;
2562: CLOSE csr_usc_defined_bal_id ;
2563: l_prsa_er_contr := PAY_BALANCE_PKG.GET_VALUE(l_prsa_er_contr_id,
2564: l_prev_source_id,
2565: g_paye_ref,
2566: null,
2567: null,

Line 3076: l_emer_num := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

3072: /* OPEN cur_defined_balance('IE EMERGENCY PERIOD');
3073: FETCH cur_defined_balance INTO l_defined_balance_id;
3074: CLOSE cur_defined_balance;
3075: hr_utility.set_location('defined balance = '||l_defined_balance_id,20);
3076: l_emer_num := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
3077: ,p_assignment_action_id => p_child_run_ass_act_id);
3078: IF l_emer_num >0 THEN
3079: l_emer_basis_flg :='Y';
3080: ELSE

Line 3128: l_soc_ben_amount := pay_balance_pkg.get_value(l_soc_ben_defined_bal_id,

3124: hr_utility.set_location('defined balance id = '||l_soc_ben_defined_bal_id,25);
3125:
3126: -- bug 5386432, call only if p_child_run_ass_act_id is not null
3127: IF p_child_run_ass_act_id IS NOT NULL THEN
3128: l_soc_ben_amount := pay_balance_pkg.get_value(l_soc_ben_defined_bal_id,
3129: p_child_run_ass_act_id
3130: ,g_paye_ref
3131: ,null
3132: ,null

Line 3494: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'

3490: FOR rec_payroll_info in csr_all_payroll_info(p_payroll_action_id)
3491: LOOP
3492: */
3493: hr_utility.trace('Entered payroll info');
3494: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
3495: , rec_payroll_info.payroll_action_id);
3496: pay_ie_p45_archive.setup_balance_definitions(p_payroll_action_id,
3497: rec_payroll_info.payroll_action_id,
3498: rec_payroll_info.effective_date);