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 948: l_excess_pf := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);

944: --
945: END LOOP;
946:
947: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess Interest Amount','_ASG_DE_PTD');
948: l_excess_pf := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
949:
950: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess PF Amount','_ASG_DE_PTD');
951: l_excess_pf := l_excess_pf + pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
952:

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

947: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess Interest Amount','_ASG_DE_PTD');
948: l_excess_pf := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
949:
950: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess PF Amount','_ASG_DE_PTD');
951: l_excess_pf := l_excess_pf + pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
952:
953:
954:
955: IF l_excess_pf <> 0 THEN

Line 2378: l_APF_value:=pay_balance_pkg.get_value(

2374: OPEN c_defined_balance_id('PF Actual Salary','_ASG_ORG_MAR_FEB_YTD');
2375: FETCH c_defined_balance_id INTO l_balance_defined_id;
2376: CLOSE c_defined_balance_id;
2377:
2378: l_APF_value:=pay_balance_pkg.get_value(
2379: p_defined_balance_id =>l_balance_defined_id,
2380: p_assignment_action_id =>p_assignment_action_id,
2381: p_tax_unit_id => null,
2382: p_jurisdiction_code => null,

Line 2393: l_VPF_value:=pay_balance_pkg.get_value(

2389: OPEN c_defined_balance_id('Employee Voluntary PF Contribution','_ASG_ORG_MAR_FEB_YTD');
2390: FETCH c_defined_balance_id INTO l_balance_defined_id;
2391: CLOSE c_defined_balance_id;
2392:
2393: l_VPF_value:=pay_balance_pkg.get_value(
2394: p_defined_balance_id =>l_balance_defined_id,
2395: p_assignment_action_id =>p_assignment_action_id,
2396: p_tax_unit_id => null,
2397: p_jurisdiction_code => null,

Line 2414: wage_value :=pay_balance_pkg.get_value(

2410: OPEN c_defined_balance_id('PF Actual Salary','_ASG_ORG_DE_PTD');
2411: FETCH c_defined_balance_id INTO l_balance_defined_id;
2412: CLOSE c_defined_balance_id;
2413:
2414: wage_value :=pay_balance_pkg.get_value(
2415: p_defined_balance_id =>l_balance_defined_id,
2416: p_assignment_action_id =>p_assignment_action_id,
2417: p_tax_unit_id =>null,
2418: p_jurisdiction_code =>null,

Line 2433: pension_fund:=pay_balance_pkg.get_value(

2429: OPEN c_defined_balance_id('EPS Contribution','_ASG_ORG_DE_PTD');
2430: FETCH c_defined_balance_id INTO l_balance_defined_id;
2431: CLOSE c_defined_balance_id;
2432:
2433: pension_fund:=pay_balance_pkg.get_value(
2434: p_defined_balance_id =>l_balance_defined_id,
2435: p_assignment_action_id =>p_assignment_action_id,
2436: p_tax_unit_id =>null,
2437: p_jurisdiction_code =>null,

Line 2451: employee_pf_value := pay_balance_pkg.get_value(

2447: OPEN c_defined_balance_id('Employee Statutory PF Contribution','_ASG_ORG_DE_PTD');
2448: FETCH c_defined_balance_id INTO l_balance_defined_id;
2449: CLOSE c_defined_balance_id;
2450:
2451: employee_pf_value := pay_balance_pkg.get_value(
2452: p_defined_balance_id =>l_balance_defined_id,
2453: p_assignment_action_id =>p_assignment_action_id,
2454: p_tax_unit_id =>null,
2455: p_jurisdiction_code =>null,

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

2467: OPEN c_defined_balance_id('Employee Voluntary PF Contribution','_ASG_ORG_DE_PTD');
2468: FETCH c_defined_balance_id INTO l_balance_defined_id;
2469: CLOSE c_defined_balance_id;
2470: pay_in_utils.set_location(g_debug,l_procedure, 200);
2471: employee_pf_value := employee_pf_value+pay_balance_pkg.get_value(
2472: p_defined_balance_id =>l_balance_defined_id,
2473: p_assignment_action_id =>p_assignment_action_id,
2474: p_tax_unit_id =>null,
2475: p_jurisdiction_code =>null,

Line 2491: l_absence := pay_balance_pkg.get_value(

2487: OPEN c_defined_balance_id('Non Contributory Period','_ASG_DE_PTD');
2488: FETCH c_defined_balance_id INTO l_balance_defined_id;
2489: CLOSE c_defined_balance_id;
2490: pay_in_utils.set_location(g_debug,l_procedure, 210);
2491: l_absence := pay_balance_pkg.get_value(
2492: p_defined_balance_id =>l_balance_defined_id,
2493: p_assignment_action_id =>p_assignment_action_id);
2494:
2495: IF g_debug THEN

Line 2509: l_eps_wages := pay_balance_pkg.get_value(

2505: pay_in_utils.trace('EPS Wages l_balance_defined_id ',l_balance_defined_id);
2506: END IF;
2507:
2508: pay_in_utils.set_location(g_debug,l_procedure, 215);
2509: l_eps_wages := pay_balance_pkg.get_value(
2510: p_defined_balance_id =>l_balance_defined_id,
2511: p_assignment_action_id =>p_assignment_action_id);
2512:
2513: IF g_debug THEN

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

2545: CLOSE c_defined_balance_id;
2546:
2547: pay_in_utils.set_location(g_debug,l_procedure, 230);
2548:
2549: l_pf_comp_salary :=pay_balance_pkg.get_value(p_defined_balance_id =>l_balance_defined_id,
2550: p_assignment_action_id =>p_assignment_action_id);
2551:
2552: IF g_debug THEN
2553: pay_in_utils.trace('PF Computation Salary PTD ',l_pf_comp_salary);

Line 2971: wage_value := pay_balance_pkg.get_value(

2967: FETCH c_defined_balance_id INTO l_balance_defined_id;
2968: CLOSE c_defined_balance_id;
2969: pay_in_utils.set_location(g_debug,l_procedure, 90);
2970:
2971: wage_value := pay_balance_pkg.get_value(
2972: p_defined_balance_id => l_balance_defined_id,
2973: p_assignment_action_id => p_assignment_action_id,
2974: p_tax_unit_id => null,
2975: p_jurisdiction_code => null,

Line 2992: l_employee_contribution :=pay_balance_pkg.get_value(

2988: CLOSE c_defined_balance_id;
2989:
2990: pay_in_utils.set_location(g_debug,l_procedure, 100);
2991:
2992: l_employee_contribution :=pay_balance_pkg.get_value(
2993: p_defined_balance_id =>l_balance_defined_id,
2994: p_assignment_action_id =>p_assignment_action_id,
2995: p_tax_unit_id => null,
2996: p_jurisdiction_code => null,

Line 3013: l_employer_contribution :=pay_balance_pkg.get_value(

3009: CLOSE c_defined_balance_id;
3010:
3011: pay_in_utils.set_location(g_debug,l_procedure, 110);
3012:
3013: l_employer_contribution :=pay_balance_pkg.get_value(
3014: p_defined_balance_id =>l_balance_defined_id,
3015: p_assignment_action_id =>p_assignment_action_id,
3016: p_tax_unit_id =>null,
3017: p_jurisdiction_code =>null,

Line 3034: l_absence := pay_balance_pkg.get_value(

3030: CLOSE c_defined_balance_id;
3031:
3032: pay_in_utils.set_location(g_debug,l_procedure, 100);
3033:
3034: l_absence := pay_balance_pkg.get_value(
3035: p_defined_balance_id =>l_balance_defined_id,
3036: p_assignment_action_id =>p_assignment_action_id
3037: );
3038:

Line 3055: l_eligible_salary := pay_balance_pkg.get_value(

3051: pay_in_utils.set_location(g_debug,l_procedure, 120);
3052:
3053:
3054:
3055: l_eligible_salary := pay_balance_pkg.get_value(
3056: p_defined_balance_id => l_balance_defined_id,
3057: p_assignment_action_id => p_assignment_action_id,
3058: p_tax_unit_id => null,
3059: p_jurisdiction_code => null,