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

Line 679: l_balance_amount := pay_balance_pkg.get_value (l_balance_id, l_asg_action_id

675: CLOSE csr_asg_act2;
676:
677: IF l_asg_action_id IS NOT NULL THEN
678: IF p_dim_name LIKE '%Balance Date%' THEN --Bug 16301893
679: l_balance_amount := pay_balance_pkg.get_value (l_balance_id, l_asg_action_id
680: , NULL, NULL
681: , NULL, NULL
682: , NULL, NULL
683: , NULL, NULL

Line 691: l_balance_amount := pay_balance_pkg.get_value

687: , NULL, NULL
688: , NULL);
689: l_balance_amount := nvl(l_balance_amount,0);
690: ELSE
691: l_balance_amount := pay_balance_pkg.get_value
692: (p_defined_balance_id => l_balance_id
693: ,p_assignment_action_id => l_asg_action_id);
694: l_balance_amount := nvl(l_balance_amount,0);
695: END IF;

Line 884: l_late_hire_ind := pay_balance_pkg.get_value( p_assignment_id => p_assignment_id

880: IF l_def_bal_id <> -1 THEN
881: --
882: -- Derive the late hire indicator value from the balance
883: --
884: l_late_hire_ind := pay_balance_pkg.get_value( p_assignment_id => p_assignment_id
885: ,p_defined_balance_id => l_def_bal_id
886: ,p_virtual_date => p_end_date);
887: END IF;
888:

Line 1644: -- Call pay_balance_pkg

1640: -- Check if Run Results exist for this element/ass act
1641: --
1642: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
1643: ,p_element_type_id => l_contr_basis(i).element_type_id ) THEN
1644: -- Call pay_balance_pkg
1645: hr_utility.trace('Run results exist for current period - Contr Basis');
1646:
1647: IF l_contr_basis(i).defined_bal_id <> -1 THEN
1648: p_contr_basis_values(k).pension_type := l_contr_basis(i).pension_type;

Line 1651: pay_balance_pkg.get_value

1647: IF l_contr_basis(i).defined_bal_id <> -1 THEN
1648: p_contr_basis_values(k).pension_type := l_contr_basis(i).pension_type;
1649: p_contr_basis_values(k).pension_type_variant := NULL;
1650: p_contr_basis_values(k).contr_base :=
1651: pay_balance_pkg.get_value
1652: (p_defined_balance_id => l_contr_basis(i).defined_bal_id
1653: ,p_assignment_action_id => act_rec.assignment_action_id);
1654:
1655: hr_utility.trace('Defined bal id used :'||l_contr_basis(i).defined_bal_id);

Line 1733: -- Call pay_balance_pkg

1729:
1730: -- Check if Run Results exist for this element/ass act
1731: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
1732: ,p_element_type_id => l_contr_basis(i).element_type_id ) THEN
1733: -- Call pay_balance_pkg
1734:
1735: IF l_contr_basis(i).defined_bal_id <> -1 THEN
1736: p_contr_basis_values(k).pension_type := l_contr_basis(i).pension_type;
1737: p_contr_basis_values(k).pension_type_variant := NULL;

Line 1739: pay_balance_pkg.get_value

1735: IF l_contr_basis(i).defined_bal_id <> -1 THEN
1736: p_contr_basis_values(k).pension_type := l_contr_basis(i).pension_type;
1737: p_contr_basis_values(k).pension_type_variant := NULL;
1738: p_contr_basis_values(k).contr_base :=
1739: pay_balance_pkg.get_value
1740: (p_defined_balance_id => l_contr_basis(i).defined_bal_id
1741: ,p_assignment_action_id => act_rec.assignment_action_id);
1742: hr_utility.trace('defined bal id used :'||l_contr_basis(i).defined_bal_id);
1743:

Line 1805: -- Call pay_balance_pkg

1801:
1802: -- Check if Run Results exist for this element/ass act
1803: IF chk_rr_exist (p_ass_act_id => act_rec.assignment_action_id
1804: ,p_element_type_id => l_contr_basis(i).element_type_id ) THEN
1805: -- Call pay_balance_pkg
1806:
1807: IF l_contr_basis(i).defined_bal_id <> -1 THEN
1808: p_contr_basis_values(k).pension_type := l_contr_basis(i).pension_type;
1809: p_contr_basis_values(k).pension_type_variant := NULL;

Line 1811: pay_balance_pkg.get_value

1807: IF l_contr_basis(i).defined_bal_id <> -1 THEN
1808: p_contr_basis_values(k).pension_type := l_contr_basis(i).pension_type;
1809: p_contr_basis_values(k).pension_type_variant := NULL;
1810: p_contr_basis_values(k).contr_base :=
1811: pay_balance_pkg.get_value
1812: (p_defined_balance_id => l_contr_basis(i).defined_bal_id
1813: ,p_assignment_action_id => act_rec.assignment_action_id);
1814: hr_utility.trace('defined bal id used :'||l_contr_basis(i).defined_bal_id);
1815:

Line 1976: l_contr_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

1972: );
1973: FETCH csr_defined_bal1 INTO l_def_bal_id;
1974: IF csr_defined_bal1%FOUND THEN
1975: CLOSE csr_defined_bal1;
1976: l_contr_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
1977: ,p_assignment_action_id => v_csr_asg_act.assignment_action_id
1978: );
1979: ELSE
1980: CLOSE csr_defined_bal1;

Line 1991: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

1987: FETCH csr_defined_bal1 INTO l_def_bal_id;
1988: IF csr_defined_bal1%FOUND THEN
1989: CLOSE csr_defined_bal1;
1990: l_contr_amt := l_contr_amt +
1991: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
1992: ,p_assignment_action_id => v_csr_asg_act.assignment_action_id
1993: );
1994: ELSE
1995: CLOSE csr_defined_bal1;

Line 2091: l_contr_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

2087: ,c_bg_id => p_bg_id);
2088: FETCH csr_defined_bal1 INTO l_def_bal_id;
2089: IF csr_defined_bal1%FOUND THEN
2090: CLOSE csr_defined_bal1;
2091: l_contr_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
2092: ,p_assignment_action_id => l_asg_act_id);
2093: ELSE
2094: CLOSE csr_defined_bal1;
2095: END IF;

Line 2105: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

2101: FETCH csr_defined_bal1 INTO l_def_bal_id;
2102: IF csr_defined_bal1%FOUND THEN
2103: CLOSE csr_defined_bal1;
2104: l_contr_amt := l_contr_amt +
2105: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
2106: ,p_assignment_action_id => l_asg_act_id);
2107: ELSE
2108: CLOSE csr_defined_bal1;
2109: END IF;

Line 2186: l_contr_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

2182: ,c_bg_id => p_bg_id);
2183: FETCH csr_defined_bal1 INTO l_def_bal_id;
2184: IF csr_defined_bal1%FOUND THEN
2185: CLOSE csr_defined_bal1;
2186: l_contr_amt := pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
2187: ,p_assignment_action_id => l_asg_act_id);
2188: ELSE
2189: CLOSE csr_defined_bal1;
2190: END IF;

Line 2200: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id

2196: FETCH csr_defined_bal1 INTO l_def_bal_id;
2197: IF csr_defined_bal1%FOUND THEN
2198: CLOSE csr_defined_bal1;
2199: l_contr_amt := l_contr_amt +
2200: pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id
2201: ,p_assignment_action_id => l_asg_act_id);
2202: ELSE
2203: CLOSE csr_defined_bal1;
2204: END IF;