DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on PAY_BALANCE_PKG

Line 946: -- pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);

942: l_return_balance_value NUMBER;
943: BEGIN
944: IF p_balance_type_id IS NOT NULL
945: THEN
946: -- pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
947: -- pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
948: OPEN csr_defined_balance_id;
949:
950: FETCH csr_defined_balance_id

Line 947: -- pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);

943: BEGIN
944: IF p_balance_type_id IS NOT NULL
945: THEN
946: -- pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
947: -- pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
948: OPEN csr_defined_balance_id;
949:
950: FETCH csr_defined_balance_id
951: INTO l_defined_balance_id;

Line 957: (pay_balance_pkg.get_value

953: CLOSE csr_defined_balance_id;
954:
955: l_return_balance_value :=
956: TO_CHAR
957: (pay_balance_pkg.get_value
958: (p_defined_balance_id => l_defined_balance_id
959: ,p_assignment_id => p_in_assignment_id
960: ,p_virtual_date => p_in_virtual_date
961: )

Line 1271: l_sal_withdrawal := nvl(pay_balance_pkg.get_value(l_sw_dim_ytd, l_assignment_id,p_effective_date),0);

1267: CLOSE csr_alecta_itp_details;
1268:
1269:
1270: l_sw_dim_ytd := defined_balance_id('Gross Salary Withdrawal','_ASG_YTD');
1271: l_sal_withdrawal := nvl(pay_balance_pkg.get_value(l_sw_dim_ytd, l_assignment_id,p_effective_date),0);
1272:
1273: -- End Changes 2008/2009
1274:
1275: -- New Entry