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 836: SELECT sum(PAY_BALANCE_PKG.GET_VALUE(l_defined_bal_id, -- changes made

832: v_class varchar2(30);
833:
834:
835: CURSOR Cur_Act_Contexts(l_defined_bal_id number,p_context_value varchar2) IS
836: SELECT sum(PAY_BALANCE_PKG.GET_VALUE(l_defined_bal_id, -- changes made
837: pac.ASSIGNMENT_ACTION_ID,
838: g_paye_ref,
839: null,
840: pac.CONTEXT_ID,

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

1189: -- previous classes concatenated with K or M
1190: -- Bug 5386432, since for terminated which does not have any element attached with FPD
1191: -- will have no child assignment actions. Call this only if child actions exists.
1192: IF pay_act_id IS NOT NULL THEN
1193: if pay_balance_pkg.get_value(k_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1194: l_prsi_cat is not NULL and l_prsi_count <> 2 then --Bug 4724788
1195: l_prsi_cat := l_prsi_cat ||', K';
1196: elsif pay_balance_pkg.get_value(k_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1197: l_prsi_cat is null then

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

1192: IF pay_act_id IS NOT NULL THEN
1193: if pay_balance_pkg.get_value(k_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1194: l_prsi_cat is not NULL and l_prsi_count <> 2 then --Bug 4724788
1195: l_prsi_cat := l_prsi_cat ||', K';
1196: elsif pay_balance_pkg.get_value(k_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1197: l_prsi_cat is null then
1198: l_prsi_cat := 'K';
1199: end if;
1200:

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

1197: l_prsi_cat is null then
1198: l_prsi_cat := 'K';
1199: end if;
1200:
1201: if pay_balance_pkg.get_value(m_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1202: l_prsi_cat is not NULL and l_prsi_count <> 2 then --Bug 4724788
1203: l_prsi_cat := l_prsi_cat ||', M';
1204: elsif pay_balance_pkg.get_value(m_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1205: l_prsi_cat is null then

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

1200:
1201: if pay_balance_pkg.get_value(m_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1202: l_prsi_cat is not NULL and l_prsi_count <> 2 then --Bug 4724788
1203: l_prsi_cat := l_prsi_cat ||', M';
1204: elsif pay_balance_pkg.get_value(m_defined_balance_id,pay_act_id,g_paye_ref,null,null,null,null,null) > 0 and
1205: l_prsi_cat is null then
1206: l_prsi_cat := 'M';
1207: end if;
1208: END IF;

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

1390: --bug 5383808. IF previous P45 exists fetch the sum of PRSI insurable
1391: -- weeks for class between the current run action sequence locked by P45
1392: -- and run action locked by previous P45.
1393: CURSOR Cur_Act_Contexts(l_defined_bal_id number) IS
1394: SELECT sum(PAY_BALANCE_PKG.GET_VALUE(l_defined_bal_id, -- changes made
1395: pac.ASSIGNMENT_ACTION_ID,
1396: g_paye_ref,
1397: null,
1398: pac.CONTEXT_ID,

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

1505: /*OPEN Cur_Act_Contexts;
1506: FETCH Cur_Act_Contexts INTO v_Cur_Act_Contexts;
1507: IF Cur_Act_Contexts%FOUND
1508: THEN
1509: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1510: v_Cur_Act_Contexts.ASSIGNMENT_ACTION_ID,
1511: null,
1512: null,
1513: v_Cur_Act_Contexts.CONTEXT_ID,

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

1522: FETCH Cur_Act_Contexts into l_balance_value;
1523: CLOSE Cur_Act_Contexts;
1524: --Bug 3079945 End
1525: /*IF nvl(p_supp_flag,'N') = 'N' AND (p_last_p45_action IS NOT NULL) then
1526: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1527: p_last_p45_action,
1528: g_paye_ref,
1529: null,
1530: null,

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

1542: l_balance_value := l_balance_value + l_pre_ins_bal;
1543: END IF;
1544: hr_utility.set_location('After IE PRSI_ClassA Insurable Weeks..'||l_pre_ins_bal,1000.1);
1545: ELSE
1546: /* l_balance_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1547: p_source_id );
1548: */
1549: --bug 5383808, call this only p_source_id is not null.
1550: if p_source_id is not null then

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

1547: p_source_id );
1548: */
1549: --bug 5383808, call this only p_source_id is not null.
1550: if p_source_id is not null then
1551: l_balance_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1552: p_source_id,
1553: g_paye_ref,
1554: null,
1555: null,

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

1564: hr_utility.set_location('sg Supp Flag ='||p_supp_flag,36);
1565: hr_utility.set_location('sg Last P45 Action ='||p_last_p45_action,37);
1566: --bug 5383808
1567: IF (p_balance like 'IE Taxable Pay') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
1568: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1569: p_prev_src_id,
1570: g_paye_ref,
1571: null,
1572: null,

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

1589: END IF;
1590:
1591:
1592: IF (p_balance like 'IE P45 Pay') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
1593: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1594: p_prev_src_id,
1595: g_paye_ref,
1596: null,
1597: null,

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

1608: END IF;
1609: END IF;
1610:
1611: IF (p_balance like 'IE P45 Tax Deducted') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
1612: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1613: p_prev_src_id,
1614: g_paye_ref,
1615: null,
1616: null,

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

1627: END IF;
1628: END IF;
1629:
1630: IF (p_balance like 'IE Net Tax') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
1631: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1632: p_prev_src_id,
1633: g_paye_ref,
1634: null,
1635: null,

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

1645: l_balance_value := l_balance_value - l_p45_last_bal_value;
1646: END IF;
1647: END IF;
1648: IF (p_balance like 'IE PRSI Insurable Weeks') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
1649: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1650: p_prev_src_id,
1651: g_paye_ref,
1652: null,
1653: null,

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

1665: END IF;
1666:
1667: -- changes made for PRSI bug 5510536. To show this employment figures only.
1668: IF (p_balance like 'IE PRSI Employer') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
1669: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1670: p_prev_src_id,
1671: g_paye_ref,
1672: null,
1673: null,

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

1684: END IF;
1685: END IF;
1686:
1687: 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
1688: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1689: p_prev_src_id,
1690: g_paye_ref,
1691: null,
1692: null,

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

1703: END IF;
1704: END IF;
1705:
1706: 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
1707: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1708: p_prev_src_id,
1709: g_paye_ref,
1710: null,
1711: null,

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

1722: END IF;
1723: END IF;
1724:
1725: IF (p_balance like 'IE PRSI Employee') AND (nvl(p_supp_flag,'N') = 'N') AND (p_last_p45_action IS NOT NULL) THEN
1726: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1727: p_prev_src_id,
1728: g_paye_ref,
1729: null,
1730: null,

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

1741: END IF;
1742: END IF;
1743:
1744: 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
1745: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1746: p_prev_src_id,
1747: g_paye_ref,
1748: null,
1749: null,

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

1760: END IF;
1761: END IF;
1762:
1763: 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
1764: l_p45_last_bal_value := PAY_BALANCE_PKG.GET_VALUE(p_defined_bal_id,
1765: p_prev_src_id,
1766: g_paye_ref,
1767: null,
1768: null,

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

1899: ELSE
1900: OPEN get_last_source_id;
1901: FETCH get_last_source_id into l_prev_source_id;
1902: CLOSE get_last_source_id;
1903: l_balance_value1 := PAY_BALANCE_PKG.GET_VALUE(p_ytd_def_bal_id,
1904: l_prev_source_id,
1905: g_paye_ref,
1906: null,
1907: null,

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

2376: /* OPEN cur_defined_balance('IE EMERGENCY PERIOD');
2377: FETCH cur_defined_balance INTO l_defined_balance_id;
2378: CLOSE cur_defined_balance;
2379: hr_utility.set_location('defined balance = '||l_defined_balance_id,20);
2380: l_emer_num := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
2381: ,p_assignment_action_id => p_child_run_ass_act_id);
2382: IF l_emer_num >0 THEN
2383: l_emer_basis_flg :='Y';
2384: ELSE

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

2428: hr_utility.set_location('defined balance id = '||l_soc_ben_defined_bal_id,25);
2429:
2430: -- bug 5386432, call only if p_child_run_ass_act_id is not null
2431: IF p_child_run_ass_act_id IS NOT NULL THEN
2432: l_soc_ben_amount := pay_balance_pkg.get_value(l_soc_ben_defined_bal_id,
2433: p_child_run_ass_act_id
2434: ,g_paye_ref
2435: ,null
2436: ,null

Line 2787: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'

2783: FOR rec_payroll_info in csr_all_payroll_info(p_payroll_action_id)
2784: LOOP
2785: */
2786: hr_utility.trace('Entered payroll info');
2787: pay_balance_pkg.set_context('PAYROLL_ACTION_ID'
2788: , rec_payroll_info.payroll_action_id);
2789: pay_ie_p45_archive.setup_balance_definitions(p_payroll_action_id,
2790: rec_payroll_info.payroll_action_id,
2791: rec_payroll_info.effective_date);