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

Line 761: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

757:
758: x := 1;
759:
760: IF t_store_def_bal(x).def_bal_id is not null THEN
761: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
762: x:= x + 1;
763: ELSE
764: l_basic_val := 0;
765: x:= x + 1;

Line 769: l_accomodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

765: x:= x + 1;
766: END IF;
767:
768: IF t_store_def_bal(x).def_bal_id is not null THEN
769: l_accomodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
770: x:= x + 1;
771: ELSE
772: l_accomodation_val := 0;
773: x:= x + 1;

Line 777: l_allowance_1_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

773: x:= x + 1;
774: END IF;
775:
776: IF t_store_def_bal(x).def_bal_id is not null THEN
777: l_allowance_1_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
778: x:= x + 1;
779: ELSE
780: l_allowance_1_val := 0;
781: x:= x + 1;

Line 785: l_allowance_2_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

781: x:= x + 1;
782: END IF;
783:
784: IF t_store_def_bal(x).def_bal_id is not null THEN
785: l_allowance_2_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
786: x:= x + 1;
787: ELSE
788: l_allowance_2_val := 0;
789: x:= x + 1;

Line 793: l_allowance_3_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

789: x:= x + 1;
790: END IF;
791:
792: IF t_store_def_bal(x).def_bal_id is not null THEN
793: l_allowance_3_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
794: x:= x + 1;
795: ELSE
796: l_allowance_3_val := 0;
797: x:= x + 1;

Line 801: l_allowance_4_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

797: x:= x + 1;
798: END IF;
799:
800: IF t_store_def_bal(x).def_bal_id is not null THEN
801: l_allowance_4_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
802: x:= x + 1;
803: ELSE
804: l_allowance_4_val := 0;
805: x:= x + 1;

Line 809: l_allowance_5_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

805: x:= x + 1;
806: END IF;
807:
808: IF t_store_def_bal(x).def_bal_id is not null THEN
809: l_allowance_5_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
810: ELSE
811: l_allowance_5_val := 0;
812: END IF;
813:

Line 1036: l_total := pay_balance_pkg.get_value(l_subject_to_social_id , t_store_assact(j).assignment_action_id);

1032:
1033: vXMLTable(vCtr).TagValue := l_fm_l_allowance_5_val;
1034: vctr := vctr + 1;
1035:
1036: l_total := pay_balance_pkg.get_value(l_subject_to_social_id , t_store_assact(j).assignment_action_id);
1037: l_fm_total_val := to_char(abs(l_total),lg_format_mask);
1038:
1039: vXMLTable(vCtr).TagName := 'total_cont_salary';
1040:

Line 1743: l_ded_val := pay_balance_pkg.get_value(l_ded_id,t_store_assact(j).assignment_action_id);

1739:
1740: l_ded_val := 0;
1741:
1742: If l_ded_id is not null then
1743: l_ded_val := pay_balance_pkg.get_value(l_ded_id,t_store_assact(j).assignment_action_id);
1744: End if;
1745:
1746: x := 1;
1747: IF t_store_def_bal(x).def_bal_id is not null THEN

Line 1748: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

1744: End if;
1745:
1746: x := 1;
1747: IF t_store_def_bal(x).def_bal_id is not null THEN
1748: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
1749: x:= x + 1;
1750: ELSE
1751: l_basic_val := 0;
1752: x:= x + 1;

Line 1755: l_accomodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

1751: l_basic_val := 0;
1752: x:= x + 1;
1753: END IF;
1754: IF t_store_def_bal(x).def_bal_id is not null THEN
1755: l_accomodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
1756: x:= x + 1;
1757: ELSE
1758: l_accomodation_val := 0;
1759: x:= x + 1;

Line 1762: l_allowance_1_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

1758: l_accomodation_val := 0;
1759: x:= x + 1;
1760: END IF;
1761: IF t_store_def_bal(x).def_bal_id is not null THEN
1762: l_allowance_1_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
1763: x:= x + 1;
1764: ELSE
1765: l_allowance_1_val := 0;
1766: x:= x + 1;

Line 1769: l_allowance_2_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

1765: l_allowance_1_val := 0;
1766: x:= x + 1;
1767: END IF;
1768: IF t_store_def_bal(x).def_bal_id is not null THEN
1769: l_allowance_2_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
1770: x:= x + 1;
1771: ELSE
1772: l_allowance_2_val := 0;
1773: x:= x + 1;

Line 1776: l_allowance_3_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

1772: l_allowance_2_val := 0;
1773: x:= x + 1;
1774: END IF;
1775: IF t_store_def_bal(x).def_bal_id is not null THEN
1776: l_allowance_3_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
1777: x:= x + 1;
1778: ELSE
1779: l_allowance_3_val := 0;
1780: x:= x + 1;

Line 1783: l_allowance_4_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

1779: l_allowance_3_val := 0;
1780: x:= x + 1;
1781: END IF;
1782: IF t_store_def_bal(x).def_bal_id is not null THEN
1783: l_allowance_4_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
1784: ELSE
1785: l_allowance_4_val := 0;
1786: END IF;
1787: l_new_count := l_new_count+1;

Line 1799: l_ee_arrears := pay_balance_pkg.get_value(l_arrears_def_bal_id,t_store_assact(j).assignment_action_id);

1795: l_fm_l_ded_val := to_char(abs(l_ded_val),lg_format_mask);
1796:
1797:
1798: If l_arrears_def_bal_id is not null then
1799: l_ee_arrears := pay_balance_pkg.get_value(l_arrears_def_bal_id,t_store_assact(j).assignment_action_id);
1800: Else
1801: l_ee_arrears := 0;
1802: End If;
1803: l_fm_ee_arrears := to_char(abs(l_ee_arrears),lg_format_mask);

Line 1918: l_total := pay_balance_pkg.get_value(l_subject_si_id,t_store_assact(j).assignment_action_id);

1914: vctr := vctr + 1;
1915:
1916: --l_total := l_basic_val + l_accomodation_val + l_allowance_1_val + l_allowance_2_val + l_allowance_3_val + l_allowance_4_val+l_allowance_5_val;
1917:
1918: l_total := pay_balance_pkg.get_value(l_subject_si_id,t_store_assact(j).assignment_action_id);
1919:
1920: l_fm_total_val := to_char(abs(l_total),lg_format_mask);
1921:
1922: vXMLTable(vCtr).TagName := 'contributory_salary_at_termination';

Line 2395: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

2391: l_allowance_4_val := 0;
2392: l_total := 0;
2393: x := 1;
2394: IF t_store_def_bal(x).def_bal_id is not null THEN
2395: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
2396: x:= x + 1;
2397: ELSE
2398: l_basic_val := 0;
2399: x:= x + 1;

Line 2402: l_accomodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

2398: l_basic_val := 0;
2399: x:= x + 1;
2400: END IF;
2401: IF t_store_def_bal(x).def_bal_id is not null THEN
2402: l_accomodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
2403: x:= x + 1;
2404: ELSE
2405: l_accomodation_val := 0;
2406: x:= x + 1;

Line 2409: l_allowance_1_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

2405: l_accomodation_val := 0;
2406: x:= x + 1;
2407: END IF;
2408: IF t_store_def_bal(x).def_bal_id is not null THEN
2409: l_allowance_1_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
2410: x:= x + 1;
2411: ELSE
2412: l_allowance_1_val := 0;
2413: x:= x + 1;

Line 2416: l_allowance_2_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

2412: l_allowance_1_val := 0;
2413: x:= x + 1;
2414: END IF;
2415: IF t_store_def_bal(x).def_bal_id is not null THEN
2416: l_allowance_2_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
2417: x:= x + 1;
2418: ELSE
2419: l_allowance_2_val := 0;
2420: x:= x + 1;

Line 2423: l_allowance_3_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

2419: l_allowance_2_val := 0;
2420: x:= x + 1;
2421: END IF;
2422: IF t_store_def_bal(x).def_bal_id is not null THEN
2423: l_allowance_3_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
2424: x:= x + 1;
2425: ELSE
2426: l_allowance_3_val := 0;
2427: x:= x + 1;

Line 2430: l_allowance_4_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

2426: l_allowance_3_val := 0;
2427: x:= x + 1;
2428: END IF;
2429: IF t_store_def_bal(x).def_bal_id is not null THEN
2430: l_allowance_4_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
2431: ELSE
2432: l_allowance_4_val := 0;
2433: END IF;
2434:

Line 2444: l_total := pay_balance_pkg.get_value(l_subject_si_id,t_store_assact(j).assignment_action_id);

2440: l_fm_l_allowance_1_val := to_char(abs(l_allowance_1_val),lg_format_mask);
2441: l_fm_l_allowance_2_val := to_char(abs(l_allowance_2_val),lg_format_mask);
2442: l_fm_l_allowance_3_val := to_char(abs(l_allowance_3_val),lg_format_mask);
2443: l_fm_l_allowance_4_val := to_char(abs(l_allowance_4_val),lg_format_mask);
2444: l_total := pay_balance_pkg.get_value(l_subject_si_id,t_store_assact(j).assignment_action_id);
2445: l_fm_total_val := to_char(abs(l_total),lg_format_mask);
2446:
2447: BEGIN
2448:

Line 2956: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));

2952: CLOSE csr_get_si_id;
2953:
2954: /* Fetch values for Social insurance contribution values for Employer */
2955: /* Set the contexts for date earned as effective date*/
2956: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
2957: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2958: l_cur_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2959: l_cur_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2960: l_cur_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);

Line 2957: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);

2953:
2954: /* Fetch values for Social insurance contribution values for Employer */
2955: /* Set the contexts for date earned as effective date*/
2956: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
2957: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2958: l_cur_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2959: l_cur_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2960: l_cur_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);
2961: l_cur_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);

Line 2958: l_cur_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);

2954: /* Fetch values for Social insurance contribution values for Employer */
2955: /* Set the contexts for date earned as effective date*/
2956: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
2957: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2958: l_cur_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2959: l_cur_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2960: l_cur_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);
2961: l_cur_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);
2962: l_cur_total := l_cur_si_er + l_cur_si_er_adj + l_cur_si_ee + l_cur_si_ee_adj;

Line 2959: l_cur_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);

2955: /* Set the contexts for date earned as effective date*/
2956: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
2957: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2958: l_cur_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2959: l_cur_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2960: l_cur_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);
2961: l_cur_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);
2962: l_cur_total := l_cur_si_er + l_cur_si_er_adj + l_cur_si_ee + l_cur_si_ee_adj;
2963:

Line 2960: l_cur_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);

2956: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(l_effective_date));
2957: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2958: l_cur_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2959: l_cur_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2960: l_cur_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);
2961: l_cur_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);
2962: l_cur_total := l_cur_si_er + l_cur_si_er_adj + l_cur_si_ee + l_cur_si_ee_adj;
2963:
2964: /* Set the contexts for date earned as previous month*/

Line 2961: l_cur_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);

2957: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2958: l_cur_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2959: l_cur_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2960: l_cur_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);
2961: l_cur_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);
2962: l_cur_total := l_cur_si_er + l_cur_si_er_adj + l_cur_si_ee + l_cur_si_ee_adj;
2963:
2964: /* Set the contexts for date earned as previous month*/
2965: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(add_months(l_effective_date,-1)));

Line 2965: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(add_months(l_effective_date,-1)));

2961: l_cur_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);
2962: l_cur_total := l_cur_si_er + l_cur_si_er_adj + l_cur_si_ee + l_cur_si_ee_adj;
2963:
2964: /* Set the contexts for date earned as previous month*/
2965: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(add_months(l_effective_date,-1)));
2966: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2967: l_prev_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2968: l_prev_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2969: l_prev_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);

Line 2966: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);

2962: l_cur_total := l_cur_si_er + l_cur_si_er_adj + l_cur_si_ee + l_cur_si_ee_adj;
2963:
2964: /* Set the contexts for date earned as previous month*/
2965: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(add_months(l_effective_date,-1)));
2966: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2967: l_prev_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2968: l_prev_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2969: l_prev_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);
2970: l_prev_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);

Line 2967: l_prev_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);

2963:
2964: /* Set the contexts for date earned as previous month*/
2965: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(add_months(l_effective_date,-1)));
2966: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2967: l_prev_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2968: l_prev_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2969: l_prev_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);
2970: l_prev_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);
2971: l_prev_total := l_prev_si_er + l_prev_si_er_adj + l_prev_si_ee + l_prev_si_ee_adj;

Line 2968: l_prev_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);

2964: /* Set the contexts for date earned as previous month*/
2965: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(add_months(l_effective_date,-1)));
2966: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2967: l_prev_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2968: l_prev_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2969: l_prev_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);
2970: l_prev_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);
2971: l_prev_total := l_prev_si_er + l_prev_si_er_adj + l_prev_si_ee + l_prev_si_ee_adj;
2972:

Line 2969: l_prev_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);

2965: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(add_months(l_effective_date,-1)));
2966: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2967: l_prev_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2968: l_prev_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2969: l_prev_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);
2970: l_prev_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);
2971: l_prev_total := l_prev_si_er + l_prev_si_er_adj + l_prev_si_ee + l_prev_si_ee_adj;
2972:
2973: l_diff_total := l_cur_total - l_prev_total;

Line 2970: l_prev_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);

2966: pay_balance_pkg.set_context('TAX_UNIT_ID', p_employer_id);
2967: l_prev_si_er := pay_balance_pkg.get_value(l_si_er_month_id,NULL);
2968: l_prev_si_er_adj := pay_balance_pkg.get_value(l_si_adj_er_month_id,NULL);
2969: l_prev_si_ee := pay_balance_pkg.get_value(l_si_ee_month_id,NULL);
2970: l_prev_si_ee_adj := pay_balance_pkg.get_value(l_si_adj_ee_month_id,NULL);
2971: l_prev_total := l_prev_si_er + l_prev_si_er_adj + l_prev_si_ee + l_prev_si_ee_adj;
2972:
2973: l_diff_total := l_cur_total - l_prev_total;
2974:

Line 3122: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,rec_get_cha_emp.assignment_action_id);

3118: FETCH csr_get_cha_emp INTO rec_get_cha_emp;
3119: EXIT WHEN csr_get_cha_emp%NOTFOUND;
3120: l_diff_exist := 0;
3121: l_subject_si_val := 0;
3122: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,rec_get_cha_emp.assignment_action_id);
3123: l_salary_effective_date := rec_get_cha_emp.date_earned;
3124: OPEN csr_get_salary_date (rec_get_cha_emp.person_id,l_effective_date);
3125: LOOP
3126: FETCH csr_get_salary_date INTO rec_get_salary_date;

Line 3128: l_prev_salary := pay_balance_pkg.get_value(l_subject_si_id,rec_get_salary_date.assignment_action_id);

3124: OPEN csr_get_salary_date (rec_get_cha_emp.person_id,l_effective_date);
3125: LOOP
3126: FETCH csr_get_salary_date INTO rec_get_salary_date;
3127: EXIT WHEN csr_get_salary_date%NOTFOUND;
3128: l_prev_salary := pay_balance_pkg.get_value(l_subject_si_id,rec_get_salary_date.assignment_action_id);
3129: IF l_prev_salary <> l_subject_si_val THEN
3130: l_diff_exist := 1;
3131: EXIT;
3132: END IF;

Line 3213: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);

3209: l_allowance_4_val := 0;
3210: l_total := 0;
3211: x := 1;
3212: IF t_store_def_bal(x).def_bal_id is not null THEN
3213: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);
3214: x:= x + 1;
3215: ELSE
3216: l_basic_val := 0;
3217: x:= x + 1;

Line 3220: l_accomodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);

3216: l_basic_val := 0;
3217: x:= x + 1;
3218: END IF;
3219: IF t_store_def_bal(x).def_bal_id is not null THEN
3220: l_accomodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);
3221: x:= x + 1;
3222: ELSE
3223: l_accomodation_val := 0;
3224: x:= x + 1;

Line 3227: l_allowance_1_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);

3223: l_accomodation_val := 0;
3224: x:= x + 1;
3225: END IF;
3226: IF t_store_def_bal(x).def_bal_id is not null THEN
3227: l_allowance_1_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);
3228: x:= x + 1;
3229: ELSE
3230: l_allowance_1_val := 0;
3231: x:= x + 1;

Line 3234: l_allowance_2_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);

3230: l_allowance_1_val := 0;
3231: x:= x + 1;
3232: END IF;
3233: IF t_store_def_bal(x).def_bal_id is not null THEN
3234: l_allowance_2_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);
3235: x:= x + 1;
3236: ELSE
3237: l_allowance_2_val := 0;
3238: x:= x + 1;

Line 3241: l_allowance_3_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);

3237: l_allowance_2_val := 0;
3238: x:= x + 1;
3239: END IF;
3240: IF t_store_def_bal(x).def_bal_id is not null THEN
3241: l_allowance_3_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);
3242: x:= x + 1;
3243: ELSE
3244: l_allowance_3_val := 0;
3245: x:= x + 1;

Line 3248: l_allowance_4_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);

3244: l_allowance_3_val := 0;
3245: x:= x + 1;
3246: END IF;
3247: IF t_store_def_bal(x).def_bal_id is not null THEN
3248: l_allowance_4_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_new_store_assact(j).assignment_action_id);
3249: ELSE
3250: l_allowance_4_val := 0;
3251: END IF;
3252: l_new_count := l_new_count+1;

Line 3266: l_total := pay_balance_pkg.get_value(l_subject_to_id ,t_new_store_assact(j).assignment_action_id);

3262: l_fm_l_allowance_4_val := to_char(abs(l_allowance_4_val),lg_format_mask);
3263:
3264: /* l_total := l_basic_val + l_accomodation_val + l_allowance_1_val + l_allowance_2_val + l_allowance_3_val + l_allowance_4_val;*/
3265:
3266: l_total := pay_balance_pkg.get_value(l_subject_to_id ,t_new_store_assact(j).assignment_action_id);
3267: l_fm_total_val := to_char(abs(l_total),lg_format_mask);
3268: l_subject_si_val := 0;
3269: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_new_store_assact(j).assignment_action_id);
3270: l_fm_subject_si_val := to_char(abs(l_subject_si_val),lg_format_mask);

Line 3269: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_new_store_assact(j).assignment_action_id);

3265:
3266: l_total := pay_balance_pkg.get_value(l_subject_to_id ,t_new_store_assact(j).assignment_action_id);
3267: l_fm_total_val := to_char(abs(l_total),lg_format_mask);
3268: l_subject_si_val := 0;
3269: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_new_store_assact(j).assignment_action_id);
3270: l_fm_subject_si_val := to_char(abs(l_subject_si_val),lg_format_mask);
3271:
3272:
3273: BEGIN

Line 3537: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_ter_store_assact(l).assignment_action_id);

3533: l_total_term := 0;
3534:
3535: WHILE l <= k LOOP
3536: l_subject_si_val := 0;
3537: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_ter_store_assact(l).assignment_action_id);
3538:
3539: OPEN csr_get_person_data(t_ter_store_assact(l).person_id,l_effective_date);
3540: FETCH csr_get_person_data INTO l_full_name;
3541: CLOSE csr_get_person_data;

Line 3639: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_cha_store_assact(n).assignment_action_id);

3635: l_total_change := 0;
3636:
3637: WHILE n <= m LOOP
3638: l_subject_si_val := 0;
3639: l_subject_si_val := pay_balance_pkg.get_value(l_subject_si_id,t_cha_store_assact(n).assignment_action_id);
3640:
3641: OPEN csr_get_person_data(t_cha_store_assact(n).person_id,l_effective_date);
3642: FETCH csr_get_person_data INTO l_full_name;
3643: CLOSE csr_get_person_data;

Line 4142: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

4138: l_allowance_4_val := 0;
4139: l_total := 0;
4140: x := 1;
4141: IF t_store_def_bal(x).def_bal_id is not null THEN
4142: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
4143: x:= x + 1;
4144: ELSE
4145: l_basic_val := 0;
4146: x:= x + 1;

Line 4149: l_accomodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

4145: l_basic_val := 0;
4146: x:= x + 1;
4147: END IF;
4148: IF t_store_def_bal(x).def_bal_id is not null THEN
4149: l_accomodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
4150: x:= x + 1;
4151: ELSE
4152: l_accomodation_val := 0;
4153: x:= x + 1;

Line 4156: l_allowance_1_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

4152: l_accomodation_val := 0;
4153: x:= x + 1;
4154: END IF;
4155: IF t_store_def_bal(x).def_bal_id is not null THEN
4156: l_allowance_1_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
4157: x:= x + 1;
4158: ELSE
4159: l_allowance_1_val := 0;
4160: x:= x + 1;

Line 4163: l_allowance_2_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

4159: l_allowance_1_val := 0;
4160: x:= x + 1;
4161: END IF;
4162: IF t_store_def_bal(x).def_bal_id is not null THEN
4163: l_allowance_2_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
4164: x:= x + 1;
4165: ELSE
4166: l_allowance_2_val := 0;
4167: x:= x + 1;

Line 4170: l_allowance_3_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

4166: l_allowance_2_val := 0;
4167: x:= x + 1;
4168: END IF;
4169: IF t_store_def_bal(x).def_bal_id is not null THEN
4170: l_allowance_3_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
4171: ELSE
4172: l_allowance_3_val := 0;
4173: END IF;
4174:

Line 4175: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));

4171: ELSE
4172: l_allowance_3_val := 0;
4173: END IF;
4174:
4175: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));
4176: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer_id);
4177:
4178: l_ee_si_val := pay_balance_pkg.get_value(l_ee_soc_ins_id,t_store_assact(j).assignment_action_id);
4179: l_er_si_val := pay_balance_pkg.get_value(l_er_soc_ins_id,t_store_assact(j).assignment_action_id);

Line 4176: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer_id);

4172: l_allowance_3_val := 0;
4173: END IF;
4174:
4175: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));
4176: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer_id);
4177:
4178: l_ee_si_val := pay_balance_pkg.get_value(l_ee_soc_ins_id,t_store_assact(j).assignment_action_id);
4179: l_er_si_val := pay_balance_pkg.get_value(l_er_soc_ins_id,t_store_assact(j).assignment_action_id);
4180: l_ee_si_adj_val := pay_balance_pkg.get_value(l_ee_soc_ins_adj_id,t_store_assact(j).assignment_action_id);

Line 4178: l_ee_si_val := pay_balance_pkg.get_value(l_ee_soc_ins_id,t_store_assact(j).assignment_action_id);

4174:
4175: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));
4176: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer_id);
4177:
4178: l_ee_si_val := pay_balance_pkg.get_value(l_ee_soc_ins_id,t_store_assact(j).assignment_action_id);
4179: l_er_si_val := pay_balance_pkg.get_value(l_er_soc_ins_id,t_store_assact(j).assignment_action_id);
4180: l_ee_si_adj_val := pay_balance_pkg.get_value(l_ee_soc_ins_adj_id,t_store_assact(j).assignment_action_id);
4181: l_er_si_adj_val := pay_balance_pkg.get_value(l_er_soc_ins_adj_id,t_store_assact(j).assignment_action_id);
4182: l_ee_si_arr_val := pay_balance_pkg.get_value(l_ee_soc_ins_arr_id,t_store_assact(j).assignment_action_id);

Line 4179: l_er_si_val := pay_balance_pkg.get_value(l_er_soc_ins_id,t_store_assact(j).assignment_action_id);

4175: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));
4176: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer_id);
4177:
4178: l_ee_si_val := pay_balance_pkg.get_value(l_ee_soc_ins_id,t_store_assact(j).assignment_action_id);
4179: l_er_si_val := pay_balance_pkg.get_value(l_er_soc_ins_id,t_store_assact(j).assignment_action_id);
4180: l_ee_si_adj_val := pay_balance_pkg.get_value(l_ee_soc_ins_adj_id,t_store_assact(j).assignment_action_id);
4181: l_er_si_adj_val := pay_balance_pkg.get_value(l_er_soc_ins_adj_id,t_store_assact(j).assignment_action_id);
4182: l_ee_si_arr_val := pay_balance_pkg.get_value(l_ee_soc_ins_arr_id,t_store_assact(j).assignment_action_id);
4183: l_er_contribution := l_er_si_val + l_er_si_adj_val;

Line 4180: l_ee_si_adj_val := pay_balance_pkg.get_value(l_ee_soc_ins_adj_id,t_store_assact(j).assignment_action_id);

4176: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer_id);
4177:
4178: l_ee_si_val := pay_balance_pkg.get_value(l_ee_soc_ins_id,t_store_assact(j).assignment_action_id);
4179: l_er_si_val := pay_balance_pkg.get_value(l_er_soc_ins_id,t_store_assact(j).assignment_action_id);
4180: l_ee_si_adj_val := pay_balance_pkg.get_value(l_ee_soc_ins_adj_id,t_store_assact(j).assignment_action_id);
4181: l_er_si_adj_val := pay_balance_pkg.get_value(l_er_soc_ins_adj_id,t_store_assact(j).assignment_action_id);
4182: l_ee_si_arr_val := pay_balance_pkg.get_value(l_ee_soc_ins_arr_id,t_store_assact(j).assignment_action_id);
4183: l_er_contribution := l_er_si_val + l_er_si_adj_val;
4184: l_ee_contribution := l_ee_si_val + l_ee_si_adj_val+l_ee_si_arr_val;

Line 4181: l_er_si_adj_val := pay_balance_pkg.get_value(l_er_soc_ins_adj_id,t_store_assact(j).assignment_action_id);

4177:
4178: l_ee_si_val := pay_balance_pkg.get_value(l_ee_soc_ins_id,t_store_assact(j).assignment_action_id);
4179: l_er_si_val := pay_balance_pkg.get_value(l_er_soc_ins_id,t_store_assact(j).assignment_action_id);
4180: l_ee_si_adj_val := pay_balance_pkg.get_value(l_ee_soc_ins_adj_id,t_store_assact(j).assignment_action_id);
4181: l_er_si_adj_val := pay_balance_pkg.get_value(l_er_soc_ins_adj_id,t_store_assact(j).assignment_action_id);
4182: l_ee_si_arr_val := pay_balance_pkg.get_value(l_ee_soc_ins_arr_id,t_store_assact(j).assignment_action_id);
4183: l_er_contribution := l_er_si_val + l_er_si_adj_val;
4184: l_ee_contribution := l_ee_si_val + l_ee_si_adj_val+l_ee_si_arr_val;
4185: l_total_contribution := l_er_contribution + l_ee_contribution;

Line 4182: l_ee_si_arr_val := pay_balance_pkg.get_value(l_ee_soc_ins_arr_id,t_store_assact(j).assignment_action_id);

4178: l_ee_si_val := pay_balance_pkg.get_value(l_ee_soc_ins_id,t_store_assact(j).assignment_action_id);
4179: l_er_si_val := pay_balance_pkg.get_value(l_er_soc_ins_id,t_store_assact(j).assignment_action_id);
4180: l_ee_si_adj_val := pay_balance_pkg.get_value(l_ee_soc_ins_adj_id,t_store_assact(j).assignment_action_id);
4181: l_er_si_adj_val := pay_balance_pkg.get_value(l_er_soc_ins_adj_id,t_store_assact(j).assignment_action_id);
4182: l_ee_si_arr_val := pay_balance_pkg.get_value(l_ee_soc_ins_arr_id,t_store_assact(j).assignment_action_id);
4183: l_er_contribution := l_er_si_val + l_er_si_adj_val;
4184: l_ee_contribution := l_ee_si_val + l_ee_si_adj_val+l_ee_si_arr_val;
4185: l_total_contribution := l_er_contribution + l_ee_contribution;
4186:

Line 4201: l_total := pay_balance_pkg.get_value(l_subject_to_id,t_store_assact(j).assignment_action_id);

4197: l_fm_l_allowance_3_val := to_char(abs(l_allowance_3_val),lg_format_mask);
4198: l_fm_l_allowance_4_val := to_char(abs(l_allowance_4_val),lg_format_mask);
4199: /*l_total := l_basic_val + l_accomodation_val + l_allowance_1_val + l_allowance_2_val + l_allowance_3_val + l_allowance_4_val;*/
4200:
4201: l_total := pay_balance_pkg.get_value(l_subject_to_id,t_store_assact(j).assignment_action_id);
4202:
4203: l_fm_total_val := to_char(abs(l_total),lg_format_mask);
4204:
4205:

Line 4840: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

4836: l_employee_adj_cont := 0;
4837: l_employer_adj_cont := 0;
4838: x := 1;
4839: IF t_store_def_bal(x).def_bal_id is not null THEN
4840: l_basic_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
4841: x:= x + 1;
4842: ELSE
4843: l_basic_val := 0;
4844: x:= x + 1;

Line 4847: l_cost_of_living_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

4843: l_basic_val := 0;
4844: x:= x + 1;
4845: END IF;
4846: IF t_store_def_bal(x).def_bal_id is not null THEN
4847: l_cost_of_living_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
4848: x:= x + 1;
4849: ELSE
4850: l_cost_of_living_val := 0;
4851: x:= x + 1;

Line 4854: l_social_allow_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

4850: l_cost_of_living_val := 0;
4851: x:= x + 1;
4852: END IF;
4853: IF t_store_def_bal(x).def_bal_id is not null THEN
4854: l_social_allow_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
4855: x:= x + 1;
4856: ELSE
4857: l_social_allow_val := 0;
4858: x:= x + 1;

Line 4861: l_child_allow_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

4857: l_social_allow_val := 0;
4858: x:= x + 1;
4859: END IF;
4860: IF t_store_def_bal(x).def_bal_id is not null THEN
4861: l_child_allow_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
4862: x:= x + 1;
4863: ELSE
4864: l_child_allow_val := 0;
4865: x:= x + 1;

Line 4868: l_accommodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);

4864: l_child_allow_val := 0;
4865: x:= x + 1;
4866: END IF;
4867: IF t_store_def_bal(x).def_bal_id is not null THEN
4868: l_accommodation_val := pay_balance_pkg.get_value(t_store_def_bal(x).def_bal_id,t_store_assact(j).assignment_action_id);
4869: x:= x + 1;
4870: ELSE
4871: l_accommodation_val := 0;
4872: x:= x + 1;

Line 4911: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));

4907: END;
4908:
4909:
4910: /* Fetch balance values for Employee SI Contribution and Employer SI Contribution */
4911: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));
4912: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer_id);
4913:
4914: OPEN csr_def_bal_id('EMPLOYEE_SOCIAL_INSURANCE_ADJUSTMENT_ASG_RUN');
4915: FETCH csr_def_bal_id INTO l_defined_balance_id;

Line 4912: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer_id);

4908:
4909:
4910: /* Fetch balance values for Employee SI Contribution and Employer SI Contribution */
4911: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date));
4912: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer_id);
4913:
4914: OPEN csr_def_bal_id('EMPLOYEE_SOCIAL_INSURANCE_ADJUSTMENT_ASG_RUN');
4915: FETCH csr_def_bal_id INTO l_defined_balance_id;
4916: CLOSE csr_def_bal_id;

Line 4918: l_employee_adj_cont := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id);

4914: OPEN csr_def_bal_id('EMPLOYEE_SOCIAL_INSURANCE_ADJUSTMENT_ASG_RUN');
4915: FETCH csr_def_bal_id INTO l_defined_balance_id;
4916: CLOSE csr_def_bal_id;
4917:
4918: l_employee_adj_cont := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id);
4919: OPEN csr_def_bal_id('EMPLOYEE_SOCIAL_INSURANCE_ARREARS_ASG_RUN');
4920: FETCH csr_def_bal_id INTO l_defined_balance_id;
4921: CLOSE csr_def_bal_id;
4922:

Line 4923: l_employee_arr_cont := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id);

4919: OPEN csr_def_bal_id('EMPLOYEE_SOCIAL_INSURANCE_ARREARS_ASG_RUN');
4920: FETCH csr_def_bal_id INTO l_defined_balance_id;
4921: CLOSE csr_def_bal_id;
4922:
4923: l_employee_arr_cont := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id);
4924: OPEN csr_def_bal_id('EMPLOYEE_SOCIAL_INSURANCE_ASG_RUN');
4925: FETCH csr_def_bal_id INTO l_defined_balance_id;
4926: CLOSE csr_def_bal_id;
4927:

Line 4928: l_employee_cont := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id) + l_employee_adj_cont + l_employee_arr_cont;

4924: OPEN csr_def_bal_id('EMPLOYEE_SOCIAL_INSURANCE_ASG_RUN');
4925: FETCH csr_def_bal_id INTO l_defined_balance_id;
4926: CLOSE csr_def_bal_id;
4927:
4928: l_employee_cont := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id) + l_employee_adj_cont + l_employee_arr_cont;
4929: OPEN csr_def_bal_id('EMPLOYER_SOCIAL_INSURANCE_ADJUSTMENT_ASG_RUN');
4930: FETCH csr_def_bal_id INTO l_defined_balance_id;
4931: CLOSE csr_def_bal_id;
4932:

Line 4933: l_employer_adj_cont := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id);

4929: OPEN csr_def_bal_id('EMPLOYER_SOCIAL_INSURANCE_ADJUSTMENT_ASG_RUN');
4930: FETCH csr_def_bal_id INTO l_defined_balance_id;
4931: CLOSE csr_def_bal_id;
4932:
4933: l_employer_adj_cont := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id);
4934: OPEN csr_def_bal_id('EMPLOYER_SOCIAL_INSURANCE_ASG_RUN');
4935: FETCH csr_def_bal_id INTO l_defined_balance_id;
4936: CLOSE csr_def_bal_id;
4937:

Line 4938: l_employer_cont := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id) + l_employer_adj_cont;

4934: OPEN csr_def_bal_id('EMPLOYER_SOCIAL_INSURANCE_ASG_RUN');
4935: FETCH csr_def_bal_id INTO l_defined_balance_id;
4936: CLOSE csr_def_bal_id;
4937:
4938: l_employer_cont := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id) + l_employer_adj_cont;
4939: OPEN csr_def_bal_id('SUBJECT_TO_SOCIAL_INSURANCE_ASG_RUN');
4940: FETCH csr_def_bal_id INTO l_defined_balance_id;
4941: CLOSE csr_def_bal_id;
4942:

Line 4943: l_total := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id);

4939: OPEN csr_def_bal_id('SUBJECT_TO_SOCIAL_INSURANCE_ASG_RUN');
4940: FETCH csr_def_bal_id INTO l_defined_balance_id;
4941: CLOSE csr_def_bal_id;
4942:
4943: l_total := pay_balance_pkg.get_value(l_defined_balance_id,t_store_assact(j).assignment_action_id);
4944: l_fm_total_val := to_char(abs(l_total),lg_format_mask);
4945: l_total_cont := l_employee_cont + l_employer_cont;
4946: l_fm_ee_cont_total := to_char(abs(l_employee_cont),lg_format_mask);
4947: l_fm_er_cont_total := to_char(abs(l_employer_cont),lg_format_mask);