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

Line 878: l_excess_pf := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);

874: --
875: END LOOP;
876:
877: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess Interest Amount','_ASG_PTD');
878: l_excess_pf := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
879:
880: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess PF Amount','_ASG_PTD');
881: l_excess_pf := l_excess_pf + pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
882:

Line 881: l_excess_pf := l_excess_pf + pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);

877: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess Interest Amount','_ASG_PTD');
878: l_excess_pf := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
879:
880: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess PF Amount','_ASG_PTD');
881: l_excess_pf := l_excess_pf + pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
882:
883:
884:
885: IF l_excess_pf <> 0 THEN

Line 2188: l_APF_value:=pay_balance_pkg.get_value(

2184: OPEN c_defined_balance_id('PF Actual Salary','_ASG_ORG_MAR_FEB_YTD');
2185: FETCH c_defined_balance_id INTO l_balance_defined_id;
2186: CLOSE c_defined_balance_id;
2187:
2188: l_APF_value:=pay_balance_pkg.get_value(
2189: p_defined_balance_id =>l_balance_defined_id,
2190: p_assignment_action_id =>p_assignment_action_id,
2191: p_tax_unit_id => null,
2192: p_jurisdiction_code => null,

Line 2203: l_VPF_value:=pay_balance_pkg.get_value(

2199: OPEN c_defined_balance_id('Employee Voluntary PF Contribution','_ASG_ORG_MAR_FEB_YTD');
2200: FETCH c_defined_balance_id INTO l_balance_defined_id;
2201: CLOSE c_defined_balance_id;
2202:
2203: l_VPF_value:=pay_balance_pkg.get_value(
2204: p_defined_balance_id =>l_balance_defined_id,
2205: p_assignment_action_id =>p_assignment_action_id,
2206: p_tax_unit_id => null,
2207: p_jurisdiction_code => null,

Line 2224: wage_value :=pay_balance_pkg.get_value(

2220: OPEN c_defined_balance_id('PF Actual Salary','_ASG_ORG_PTD');
2221: FETCH c_defined_balance_id INTO l_balance_defined_id;
2222: CLOSE c_defined_balance_id;
2223:
2224: wage_value :=pay_balance_pkg.get_value(
2225: p_defined_balance_id =>l_balance_defined_id,
2226: p_assignment_action_id =>p_assignment_action_id,
2227: p_tax_unit_id =>null,
2228: p_jurisdiction_code =>null,

Line 2243: pension_fund:=pay_balance_pkg.get_value(

2239: OPEN c_defined_balance_id('EPS Contribution','_ASG_ORG_PTD');
2240: FETCH c_defined_balance_id INTO l_balance_defined_id;
2241: CLOSE c_defined_balance_id;
2242:
2243: pension_fund:=pay_balance_pkg.get_value(
2244: p_defined_balance_id =>l_balance_defined_id,
2245: p_assignment_action_id =>p_assignment_action_id,
2246: p_tax_unit_id =>null,
2247: p_jurisdiction_code =>null,

Line 2261: employee_pf_value := pay_balance_pkg.get_value(

2257: OPEN c_defined_balance_id('Employee Statutory PF Contribution','_ASG_ORG_PTD');
2258: FETCH c_defined_balance_id INTO l_balance_defined_id;
2259: CLOSE c_defined_balance_id;
2260:
2261: employee_pf_value := pay_balance_pkg.get_value(
2262: p_defined_balance_id =>l_balance_defined_id,
2263: p_assignment_action_id =>p_assignment_action_id,
2264: p_tax_unit_id =>null,
2265: p_jurisdiction_code =>null,

Line 2281: employee_pf_value := employee_pf_value+pay_balance_pkg.get_value(

2277: OPEN c_defined_balance_id('Employee Voluntary PF Contribution','_ASG_ORG_PTD');
2278: FETCH c_defined_balance_id INTO l_balance_defined_id;
2279: CLOSE c_defined_balance_id;
2280: pay_in_utils.set_location(g_debug,l_procedure, 200);
2281: employee_pf_value := employee_pf_value+pay_balance_pkg.get_value(
2282: p_defined_balance_id =>l_balance_defined_id,
2283: p_assignment_action_id =>p_assignment_action_id,
2284: p_tax_unit_id =>null,
2285: p_jurisdiction_code =>null,

Line 2301: l_absence := pay_balance_pkg.get_value(

2297: OPEN c_defined_balance_id('Non Contributory Period','_ASG_PTD');
2298: FETCH c_defined_balance_id INTO l_balance_defined_id;
2299: CLOSE c_defined_balance_id;
2300: pay_in_utils.set_location(g_debug,l_procedure, 210);
2301: l_absence := pay_balance_pkg.get_value(
2302: p_defined_balance_id =>l_balance_defined_id,
2303: p_assignment_action_id =>p_assignment_action_id);
2304:
2305: IF g_debug THEN

Line 2337: l_pf_comp_salary :=pay_balance_pkg.get_value(p_defined_balance_id =>l_balance_defined_id,

2333: CLOSE c_defined_balance_id;
2334:
2335: pay_in_utils.set_location(g_debug,l_procedure, 230);
2336:
2337: l_pf_comp_salary :=pay_balance_pkg.get_value(p_defined_balance_id =>l_balance_defined_id,
2338: p_assignment_action_id =>p_assignment_action_id);
2339:
2340: IF g_debug THEN
2341: pay_in_utils.trace('PF Computation Salary PTD ',l_pf_comp_salary);

Line 2759: wage_value := pay_balance_pkg.get_value(

2755: FETCH c_defined_balance_id INTO l_balance_defined_id;
2756: CLOSE c_defined_balance_id;
2757: pay_in_utils.set_location(g_debug,l_procedure, 90);
2758:
2759: wage_value := pay_balance_pkg.get_value(
2760: p_defined_balance_id => l_balance_defined_id,
2761: p_assignment_action_id => p_assignment_action_id,
2762: p_tax_unit_id => null,
2763: p_jurisdiction_code => null,

Line 2780: l_employee_contribution :=pay_balance_pkg.get_value(

2776: CLOSE c_defined_balance_id;
2777:
2778: pay_in_utils.set_location(g_debug,l_procedure, 100);
2779:
2780: l_employee_contribution :=pay_balance_pkg.get_value(
2781: p_defined_balance_id =>l_balance_defined_id,
2782: p_assignment_action_id =>p_assignment_action_id,
2783: p_tax_unit_id => null,
2784: p_jurisdiction_code => null,

Line 2801: l_employer_contribution :=pay_balance_pkg.get_value(

2797: CLOSE c_defined_balance_id;
2798:
2799: pay_in_utils.set_location(g_debug,l_procedure, 110);
2800:
2801: l_employer_contribution :=pay_balance_pkg.get_value(
2802: p_defined_balance_id =>l_balance_defined_id,
2803: p_assignment_action_id =>p_assignment_action_id,
2804: p_tax_unit_id =>null,
2805: p_jurisdiction_code =>null,

Line 2822: l_absence := pay_balance_pkg.get_value(

2818: CLOSE c_defined_balance_id;
2819:
2820: pay_in_utils.set_location(g_debug,l_procedure, 100);
2821:
2822: l_absence := pay_balance_pkg.get_value(
2823: p_defined_balance_id =>l_balance_defined_id,
2824: p_assignment_action_id =>p_assignment_action_id
2825: );
2826:

Line 2843: l_eligible_salary := pay_balance_pkg.get_value(

2839: pay_in_utils.set_location(g_debug,l_procedure, 120);
2840:
2841:
2842:
2843: l_eligible_salary := pay_balance_pkg.get_value(
2844: p_defined_balance_id => l_balance_defined_id,
2845: p_assignment_action_id => p_assignment_action_id,
2846: p_tax_unit_id => null,
2847: p_jurisdiction_code => null,