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

Line 684: l_temp := pay_balance_pkg.get_value(l_defined_balance_id, l_assact_id_new);

680: close get_assact_id_new;
681: /*Call the package to get the monthly contribution*/
682: if l_assact_id_new is not null then
683:
684: l_temp := pay_balance_pkg.get_value(l_defined_balance_id, l_assact_id_new);
685: IF(l_temp > to_number(l_upper_base)) THEN
686: l_temp := to_number(l_upper_base);
687: ELSIF(l_temp < to_number(l_lower_base)) THEN
688: l_temp := to_number(l_lower_base);

Line 886: l_temp_term := pay_balance_pkg.get_value(l_defined_balance_id, l_assact_id_term);

882: fetch get_assact_id_term into l_assact_id_term;
883: close get_assact_id_term;
884: if l_assact_id_term is not null then
885:
886: l_temp_term := pay_balance_pkg.get_value(l_defined_balance_id, l_assact_id_term);
887: IF(l_temp_term > to_number(l_upper_base)) THEN
888: l_temp_term := to_number(l_upper_base);
889: ELSIF(l_temp_term < to_number(l_lower_base)) THEN
890: l_temp_term := to_number(l_lower_base);

Line 1575: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);

1571: vctr := vctr + 1;
1572: vXMLTable(vCtr).TagName := 'G4-A-05-9';
1573: vXMLTable(vCtr).TagValue := SUBSTR(l_employer_gosi_number,1,1);
1574: vctr := vctr + 1;
1575: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1576: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));
1577: /***To fetch for pprevious months, using existing emp + new + terminated after 28th *****/
1578: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1579: pay_balance_pkg.set_context('SOURCE_TEXT','N');

Line 1576: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));

1572: vXMLTable(vCtr).TagName := 'G4-A-05-9';
1573: vXMLTable(vCtr).TagValue := SUBSTR(l_employer_gosi_number,1,1);
1574: vctr := vctr + 1;
1575: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1576: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));
1577: /***To fetch for pprevious months, using existing emp + new + terminated after 28th *****/
1578: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1579: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1580: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

Line 1578: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

1574: vctr := vctr + 1;
1575: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1576: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));
1577: /***To fetch for pprevious months, using existing emp + new + terminated after 28th *****/
1578: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1579: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1580: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1581: l_prev_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1582: l_prev_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);

Line 1579: pay_balance_pkg.set_context('SOURCE_TEXT','N');

1575: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1576: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));
1577: /***To fetch for pprevious months, using existing emp + new + terminated after 28th *****/
1578: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1579: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1580: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1581: l_prev_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1582: l_prev_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1583: l_prev_haz_ann_saudi := l_prev_ann_saudi + l_prev_haz_saudi;

Line 1580: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

1576: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));
1577: /***To fetch for pprevious months, using existing emp + new + terminated after 28th *****/
1578: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1579: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1580: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1581: l_prev_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1582: l_prev_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1583: l_prev_haz_ann_saudi := l_prev_ann_saudi + l_prev_haz_saudi;
1584: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

Line 1581: l_prev_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);

1577: /***To fetch for pprevious months, using existing emp + new + terminated after 28th *****/
1578: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1579: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1580: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1581: l_prev_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1582: l_prev_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1583: l_prev_haz_ann_saudi := l_prev_ann_saudi + l_prev_haz_saudi;
1584: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1585: pay_balance_pkg.set_context('SOURCE_TEXT','N');

Line 1582: l_prev_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);

1578: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1579: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1580: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1581: l_prev_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1582: l_prev_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1583: l_prev_haz_ann_saudi := l_prev_ann_saudi + l_prev_haz_saudi;
1584: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1585: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1586: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

Line 1584: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

1580: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1581: l_prev_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1582: l_prev_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1583: l_prev_haz_ann_saudi := l_prev_ann_saudi + l_prev_haz_saudi;
1584: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1585: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1586: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1587: l_prev_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1588: l_prev_haz_all := l_prev_haz_saudi + l_prev_haz;

Line 1585: pay_balance_pkg.set_context('SOURCE_TEXT','N');

1581: l_prev_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1582: l_prev_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1583: l_prev_haz_ann_saudi := l_prev_ann_saudi + l_prev_haz_saudi;
1584: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1585: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1586: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1587: l_prev_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1588: l_prev_haz_all := l_prev_haz_saudi + l_prev_haz;
1589: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

Line 1586: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

1582: l_prev_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1583: l_prev_haz_ann_saudi := l_prev_ann_saudi + l_prev_haz_saudi;
1584: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1585: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1586: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1587: l_prev_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1588: l_prev_haz_all := l_prev_haz_saudi + l_prev_haz;
1589: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1590: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

Line 1587: l_prev_haz := pay_balance_pkg.get_value(l_haz_month_db,null);

1583: l_prev_haz_ann_saudi := l_prev_ann_saudi + l_prev_haz_saudi;
1584: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1585: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1586: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1587: l_prev_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1588: l_prev_haz_all := l_prev_haz_saudi + l_prev_haz;
1589: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1590: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1591: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

Line 1589: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

1585: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1586: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1587: l_prev_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1588: l_prev_haz_all := l_prev_haz_saudi + l_prev_haz;
1589: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1590: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1591: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1592: l_prev_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1593: l_prev_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);

Line 1590: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

1586: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1587: l_prev_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1588: l_prev_haz_all := l_prev_haz_saudi + l_prev_haz;
1589: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1590: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1591: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1592: l_prev_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1593: l_prev_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1594: l_prev_haz_ann_saudi_new := l_prev_ann_saudi_new + l_prev_haz_saudi_new;

Line 1591: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

1587: l_prev_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1588: l_prev_haz_all := l_prev_haz_saudi + l_prev_haz;
1589: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1590: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1591: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1592: l_prev_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1593: l_prev_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1594: l_prev_haz_ann_saudi_new := l_prev_ann_saudi_new + l_prev_haz_saudi_new;
1595: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

Line 1592: l_prev_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);

1588: l_prev_haz_all := l_prev_haz_saudi + l_prev_haz;
1589: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1590: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1591: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1592: l_prev_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1593: l_prev_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1594: l_prev_haz_ann_saudi_new := l_prev_ann_saudi_new + l_prev_haz_saudi_new;
1595: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1596: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

Line 1593: l_prev_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);

1589: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1590: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1591: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1592: l_prev_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1593: l_prev_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1594: l_prev_haz_ann_saudi_new := l_prev_ann_saudi_new + l_prev_haz_saudi_new;
1595: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1596: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1597: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

Line 1595: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

1591: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1592: l_prev_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1593: l_prev_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1594: l_prev_haz_ann_saudi_new := l_prev_ann_saudi_new + l_prev_haz_saudi_new;
1595: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1596: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1597: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1598: l_prev_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1599: l_prev_haz_new_all := l_prev_haz_saudi_new + l_prev_haz_new;

Line 1596: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

1592: l_prev_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1593: l_prev_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1594: l_prev_haz_ann_saudi_new := l_prev_ann_saudi_new + l_prev_haz_saudi_new;
1595: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1596: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1597: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1598: l_prev_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1599: l_prev_haz_new_all := l_prev_haz_saudi_new + l_prev_haz_new;
1600: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

Line 1597: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

1593: l_prev_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1594: l_prev_haz_ann_saudi_new := l_prev_ann_saudi_new + l_prev_haz_saudi_new;
1595: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1596: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1597: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1598: l_prev_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1599: l_prev_haz_new_all := l_prev_haz_saudi_new + l_prev_haz_new;
1600: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1601: pay_balance_pkg.set_context('SOURCE_TEXT','N');

Line 1598: l_prev_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);

1594: l_prev_haz_ann_saudi_new := l_prev_ann_saudi_new + l_prev_haz_saudi_new;
1595: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1596: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1597: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1598: l_prev_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1599: l_prev_haz_new_all := l_prev_haz_saudi_new + l_prev_haz_new;
1600: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1601: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1602: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

Line 1600: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

1596: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1597: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1598: l_prev_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1599: l_prev_haz_new_all := l_prev_haz_saudi_new + l_prev_haz_new;
1600: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1601: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1602: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1603: l_prev_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1604: l_prev_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

Line 1601: pay_balance_pkg.set_context('SOURCE_TEXT','N');

1597: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1598: l_prev_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1599: l_prev_haz_new_all := l_prev_haz_saudi_new + l_prev_haz_new;
1600: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1601: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1602: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1603: l_prev_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1604: l_prev_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1605: l_prev_haz_ann_saudi_ter := l_prev_ann_saudi_ter + l_prev_haz_saudi_ter;

Line 1602: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

1598: l_prev_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1599: l_prev_haz_new_all := l_prev_haz_saudi_new + l_prev_haz_new;
1600: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1601: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1602: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1603: l_prev_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1604: l_prev_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1605: l_prev_haz_ann_saudi_ter := l_prev_ann_saudi_ter + l_prev_haz_saudi_ter;
1606: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

Line 1603: l_prev_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);

1599: l_prev_haz_new_all := l_prev_haz_saudi_new + l_prev_haz_new;
1600: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1601: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1602: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1603: l_prev_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1604: l_prev_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1605: l_prev_haz_ann_saudi_ter := l_prev_ann_saudi_ter + l_prev_haz_saudi_ter;
1606: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1607: pay_balance_pkg.set_context('SOURCE_TEXT','N');

Line 1604: l_prev_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

1600: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1601: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1602: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1603: l_prev_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1604: l_prev_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1605: l_prev_haz_ann_saudi_ter := l_prev_ann_saudi_ter + l_prev_haz_saudi_ter;
1606: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1607: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1608: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

Line 1606: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

1602: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1603: l_prev_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1604: l_prev_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1605: l_prev_haz_ann_saudi_ter := l_prev_ann_saudi_ter + l_prev_haz_saudi_ter;
1606: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1607: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1608: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1609: l_prev_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1610: l_prev_haz_ter_all := l_prev_haz_saudi_ter + l_prev_haz_ter;

Line 1607: pay_balance_pkg.set_context('SOURCE_TEXT','N');

1603: l_prev_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1604: l_prev_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1605: l_prev_haz_ann_saudi_ter := l_prev_ann_saudi_ter + l_prev_haz_saudi_ter;
1606: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1607: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1608: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1609: l_prev_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1610: l_prev_haz_ter_all := l_prev_haz_saudi_ter + l_prev_haz_ter;
1611: /*Following code for joiner-leaver (after 28th) in same month*/

Line 1608: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

1604: l_prev_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1605: l_prev_haz_ann_saudi_ter := l_prev_ann_saudi_ter + l_prev_haz_saudi_ter;
1606: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1607: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1608: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1609: l_prev_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1610: l_prev_haz_ter_all := l_prev_haz_saudi_ter + l_prev_haz_ter;
1611: /*Following code for joiner-leaver (after 28th) in same month*/
1612: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

Line 1609: l_prev_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

1605: l_prev_haz_ann_saudi_ter := l_prev_ann_saudi_ter + l_prev_haz_saudi_ter;
1606: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1607: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1608: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1609: l_prev_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1610: l_prev_haz_ter_all := l_prev_haz_saudi_ter + l_prev_haz_ter;
1611: /*Following code for joiner-leaver (after 28th) in same month*/
1612: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1613: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

Line 1612: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

1608: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1609: l_prev_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1610: l_prev_haz_ter_all := l_prev_haz_saudi_ter + l_prev_haz_ter;
1611: /*Following code for joiner-leaver (after 28th) in same month*/
1612: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1613: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1614: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1615: l_prev_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1616: l_prev_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

Line 1613: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

1609: l_prev_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1610: l_prev_haz_ter_all := l_prev_haz_saudi_ter + l_prev_haz_ter;
1611: /*Following code for joiner-leaver (after 28th) in same month*/
1612: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1613: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1614: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1615: l_prev_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1616: l_prev_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1617: l_prev_haz_ann_saudi_new_ter := l_prev_ann_saudi_new_ter + l_prev_haz_saudi_new_ter;

Line 1614: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

1610: l_prev_haz_ter_all := l_prev_haz_saudi_ter + l_prev_haz_ter;
1611: /*Following code for joiner-leaver (after 28th) in same month*/
1612: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1613: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1614: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1615: l_prev_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1616: l_prev_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1617: l_prev_haz_ann_saudi_new_ter := l_prev_ann_saudi_new_ter + l_prev_haz_saudi_new_ter;
1618: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

Line 1615: l_prev_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);

1611: /*Following code for joiner-leaver (after 28th) in same month*/
1612: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1613: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1614: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1615: l_prev_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1616: l_prev_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1617: l_prev_haz_ann_saudi_new_ter := l_prev_ann_saudi_new_ter + l_prev_haz_saudi_new_ter;
1618: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1619: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

Line 1616: l_prev_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

1612: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1613: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1614: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1615: l_prev_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1616: l_prev_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1617: l_prev_haz_ann_saudi_new_ter := l_prev_ann_saudi_new_ter + l_prev_haz_saudi_new_ter;
1618: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1619: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1620: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

Line 1618: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

1614: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1615: l_prev_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1616: l_prev_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1617: l_prev_haz_ann_saudi_new_ter := l_prev_ann_saudi_new_ter + l_prev_haz_saudi_new_ter;
1618: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1619: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1620: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1621: l_prev_haz_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1622: l_prev_haz_new_ter_all := l_prev_haz_saudi_new_ter + l_prev_haz_new_ter;

Line 1619: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

1615: l_prev_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1616: l_prev_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1617: l_prev_haz_ann_saudi_new_ter := l_prev_ann_saudi_new_ter + l_prev_haz_saudi_new_ter;
1618: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1619: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1620: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1621: l_prev_haz_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1622: l_prev_haz_new_ter_all := l_prev_haz_saudi_new_ter + l_prev_haz_new_ter;
1623: l_tot_prev_ann_saudi := l_prev_ann_saudi + l_prev_ann_saudi_new + l_prev_ann_saudi_ter + l_prev_ann_saudi_new_ter;

Line 1620: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

1616: l_prev_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1617: l_prev_haz_ann_saudi_new_ter := l_prev_ann_saudi_new_ter + l_prev_haz_saudi_new_ter;
1618: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1619: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1620: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1621: l_prev_haz_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1622: l_prev_haz_new_ter_all := l_prev_haz_saudi_new_ter + l_prev_haz_new_ter;
1623: l_tot_prev_ann_saudi := l_prev_ann_saudi + l_prev_ann_saudi_new + l_prev_ann_saudi_ter + l_prev_ann_saudi_new_ter;
1624: l_tot_prev_haz_all := l_prev_haz_all + l_prev_haz_new_all + l_prev_haz_ter_all + l_prev_haz_new_ter_all;

Line 1621: l_prev_haz_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

1617: l_prev_haz_ann_saudi_new_ter := l_prev_ann_saudi_new_ter + l_prev_haz_saudi_new_ter;
1618: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1619: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1620: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1621: l_prev_haz_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1622: l_prev_haz_new_ter_all := l_prev_haz_saudi_new_ter + l_prev_haz_new_ter;
1623: l_tot_prev_ann_saudi := l_prev_ann_saudi + l_prev_ann_saudi_new + l_prev_ann_saudi_ter + l_prev_ann_saudi_new_ter;
1624: l_tot_prev_haz_all := l_prev_haz_all + l_prev_haz_new_all + l_prev_haz_ter_all + l_prev_haz_new_ter_all;
1625: l_tot_prev_haz_ann_saudi := l_prev_haz_ann_saudi + l_prev_haz_ann_saudi_new + l_prev_haz_ann_saudi_ter + l_prev_haz_ann_saudi_new_ter;

Line 1627: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_effective_date));

1623: l_tot_prev_ann_saudi := l_prev_ann_saudi + l_prev_ann_saudi_new + l_prev_ann_saudi_ter + l_prev_ann_saudi_new_ter;
1624: l_tot_prev_haz_all := l_prev_haz_all + l_prev_haz_new_all + l_prev_haz_ter_all + l_prev_haz_new_ter_all;
1625: l_tot_prev_haz_ann_saudi := l_prev_haz_ann_saudi + l_prev_haz_ann_saudi_new + l_prev_haz_ann_saudi_ter + l_prev_haz_ann_saudi_new_ter;
1626: /*******************************************************/
1627: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_effective_date));
1628: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1629: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1630: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1631: l_curr_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);

Line 1628: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

1624: l_tot_prev_haz_all := l_prev_haz_all + l_prev_haz_new_all + l_prev_haz_ter_all + l_prev_haz_new_ter_all;
1625: l_tot_prev_haz_ann_saudi := l_prev_haz_ann_saudi + l_prev_haz_ann_saudi_new + l_prev_haz_ann_saudi_ter + l_prev_haz_ann_saudi_new_ter;
1626: /*******************************************************/
1627: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_effective_date));
1628: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1629: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1630: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1631: l_curr_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1632: l_curr_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);

Line 1629: pay_balance_pkg.set_context('SOURCE_TEXT','N');

1625: l_tot_prev_haz_ann_saudi := l_prev_haz_ann_saudi + l_prev_haz_ann_saudi_new + l_prev_haz_ann_saudi_ter + l_prev_haz_ann_saudi_new_ter;
1626: /*******************************************************/
1627: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_effective_date));
1628: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1629: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1630: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1631: l_curr_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1632: l_curr_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1633: l_curr_haz_ann_saudi := l_curr_ann_saudi + l_curr_haz_saudi;

Line 1630: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

1626: /*******************************************************/
1627: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_effective_date));
1628: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1629: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1630: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1631: l_curr_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1632: l_curr_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1633: l_curr_haz_ann_saudi := l_curr_ann_saudi + l_curr_haz_saudi;
1634: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

Line 1631: l_curr_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);

1627: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_effective_date));
1628: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1629: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1630: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1631: l_curr_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1632: l_curr_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1633: l_curr_haz_ann_saudi := l_curr_ann_saudi + l_curr_haz_saudi;
1634: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1635: pay_balance_pkg.set_context('SOURCE_TEXT','N');

Line 1632: l_curr_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);

1628: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1629: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1630: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1631: l_curr_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1632: l_curr_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1633: l_curr_haz_ann_saudi := l_curr_ann_saudi + l_curr_haz_saudi;
1634: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1635: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1636: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

Line 1634: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

1630: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1631: l_curr_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1632: l_curr_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1633: l_curr_haz_ann_saudi := l_curr_ann_saudi + l_curr_haz_saudi;
1634: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1635: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1636: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1637: l_curr_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1638: l_curr_haz_all := l_curr_haz_saudi + l_curr_haz;

Line 1635: pay_balance_pkg.set_context('SOURCE_TEXT','N');

1631: l_curr_ann_saudi := pay_balance_pkg.get_value(l_ann_month_db,null);
1632: l_curr_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1633: l_curr_haz_ann_saudi := l_curr_ann_saudi + l_curr_haz_saudi;
1634: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1635: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1636: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1637: l_curr_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1638: l_curr_haz_all := l_curr_haz_saudi + l_curr_haz;
1639: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

Line 1636: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

1632: l_curr_haz_saudi := pay_balance_pkg.get_value(l_haz_month_db,null);
1633: l_curr_haz_ann_saudi := l_curr_ann_saudi + l_curr_haz_saudi;
1634: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1635: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1636: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1637: l_curr_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1638: l_curr_haz_all := l_curr_haz_saudi + l_curr_haz;
1639: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1640: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

Line 1637: l_curr_haz := pay_balance_pkg.get_value(l_haz_month_db,null);

1633: l_curr_haz_ann_saudi := l_curr_ann_saudi + l_curr_haz_saudi;
1634: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1635: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1636: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1637: l_curr_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1638: l_curr_haz_all := l_curr_haz_saudi + l_curr_haz;
1639: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1640: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1641: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

Line 1639: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

1635: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1636: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1637: l_curr_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1638: l_curr_haz_all := l_curr_haz_saudi + l_curr_haz;
1639: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1640: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1641: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1642: l_curr_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1643: l_curr_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);

Line 1640: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

1636: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1637: l_curr_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1638: l_curr_haz_all := l_curr_haz_saudi + l_curr_haz;
1639: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1640: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1641: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1642: l_curr_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1643: l_curr_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1644: l_curr_haz_ann_saudi_new := l_curr_ann_saudi_new + l_curr_haz_saudi_new;

Line 1641: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

1637: l_curr_haz := pay_balance_pkg.get_value(l_haz_month_db,null);
1638: l_curr_haz_all := l_curr_haz_saudi + l_curr_haz;
1639: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1640: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1641: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1642: l_curr_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1643: l_curr_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1644: l_curr_haz_ann_saudi_new := l_curr_ann_saudi_new + l_curr_haz_saudi_new;
1645: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

Line 1642: l_curr_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);

1638: l_curr_haz_all := l_curr_haz_saudi + l_curr_haz;
1639: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1640: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1641: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1642: l_curr_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1643: l_curr_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1644: l_curr_haz_ann_saudi_new := l_curr_ann_saudi_new + l_curr_haz_saudi_new;
1645: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1646: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

Line 1643: l_curr_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);

1639: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1640: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1641: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1642: l_curr_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1643: l_curr_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1644: l_curr_haz_ann_saudi_new := l_curr_ann_saudi_new + l_curr_haz_saudi_new;
1645: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1646: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1647: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

Line 1645: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

1641: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1642: l_curr_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1643: l_curr_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1644: l_curr_haz_ann_saudi_new := l_curr_ann_saudi_new + l_curr_haz_saudi_new;
1645: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1646: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1647: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1648: l_curr_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1649: l_curr_haz_new_all := l_curr_haz_saudi_new + l_curr_haz_new;

Line 1646: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

1642: l_curr_ann_saudi_new := pay_balance_pkg.get_value(l_ann_month_db,null);
1643: l_curr_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1644: l_curr_haz_ann_saudi_new := l_curr_ann_saudi_new + l_curr_haz_saudi_new;
1645: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1646: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1647: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1648: l_curr_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1649: l_curr_haz_new_all := l_curr_haz_saudi_new + l_curr_haz_new;
1650: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

Line 1647: pay_balance_pkg.set_context('SOURCE_TEXT2','N');

1643: l_curr_haz_saudi_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1644: l_curr_haz_ann_saudi_new := l_curr_ann_saudi_new + l_curr_haz_saudi_new;
1645: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1646: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1647: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1648: l_curr_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1649: l_curr_haz_new_all := l_curr_haz_saudi_new + l_curr_haz_new;
1650: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1651: pay_balance_pkg.set_context('SOURCE_TEXT','N');

Line 1648: l_curr_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);

1644: l_curr_haz_ann_saudi_new := l_curr_ann_saudi_new + l_curr_haz_saudi_new;
1645: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1646: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1647: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1648: l_curr_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1649: l_curr_haz_new_all := l_curr_haz_saudi_new + l_curr_haz_new;
1650: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1651: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1652: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

Line 1650: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

1646: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1647: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1648: l_curr_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1649: l_curr_haz_new_all := l_curr_haz_saudi_new + l_curr_haz_new;
1650: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1651: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1652: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1653: l_curr_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1654: l_curr_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

Line 1651: pay_balance_pkg.set_context('SOURCE_TEXT','N');

1647: pay_balance_pkg.set_context('SOURCE_TEXT2','N');
1648: l_curr_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1649: l_curr_haz_new_all := l_curr_haz_saudi_new + l_curr_haz_new;
1650: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1651: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1652: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1653: l_curr_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1654: l_curr_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1655: l_curr_haz_ann_saudi_ter := l_curr_ann_saudi_ter + l_curr_haz_saudi_ter;

Line 1652: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

1648: l_curr_haz_new := pay_balance_pkg.get_value(l_haz_month_db,null);
1649: l_curr_haz_new_all := l_curr_haz_saudi_new + l_curr_haz_new;
1650: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1651: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1652: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1653: l_curr_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1654: l_curr_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1655: l_curr_haz_ann_saudi_ter := l_curr_ann_saudi_ter + l_curr_haz_saudi_ter;
1656: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

Line 1653: l_curr_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);

1649: l_curr_haz_new_all := l_curr_haz_saudi_new + l_curr_haz_new;
1650: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1651: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1652: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1653: l_curr_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1654: l_curr_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1655: l_curr_haz_ann_saudi_ter := l_curr_ann_saudi_ter + l_curr_haz_saudi_ter;
1656: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1657: pay_balance_pkg.set_context('SOURCE_TEXT','N');

Line 1654: l_curr_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

1650: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1651: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1652: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1653: l_curr_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1654: l_curr_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1655: l_curr_haz_ann_saudi_ter := l_curr_ann_saudi_ter + l_curr_haz_saudi_ter;
1656: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1657: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1658: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

Line 1656: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

1652: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1653: l_curr_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1654: l_curr_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1655: l_curr_haz_ann_saudi_ter := l_curr_ann_saudi_ter + l_curr_haz_saudi_ter;
1656: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1657: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1658: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1659: l_curr_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1660: l_curr_haz_ter_all := l_curr_haz_saudi_ter + l_curr_haz_ter;

Line 1657: pay_balance_pkg.set_context('SOURCE_TEXT','N');

1653: l_curr_ann_saudi_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1654: l_curr_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1655: l_curr_haz_ann_saudi_ter := l_curr_ann_saudi_ter + l_curr_haz_saudi_ter;
1656: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1657: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1658: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1659: l_curr_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1660: l_curr_haz_ter_all := l_curr_haz_saudi_ter + l_curr_haz_ter;
1661: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

Line 1658: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

1654: l_curr_haz_saudi_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1655: l_curr_haz_ann_saudi_ter := l_curr_ann_saudi_ter + l_curr_haz_saudi_ter;
1656: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1657: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1658: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1659: l_curr_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1660: l_curr_haz_ter_all := l_curr_haz_saudi_ter + l_curr_haz_ter;
1661: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1662: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

Line 1659: l_curr_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

1655: l_curr_haz_ann_saudi_ter := l_curr_ann_saudi_ter + l_curr_haz_saudi_ter;
1656: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1657: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1658: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1659: l_curr_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1660: l_curr_haz_ter_all := l_curr_haz_saudi_ter + l_curr_haz_ter;
1661: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1662: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1663: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

Line 1661: pay_balance_pkg.set_context('SOURCE_NUMBER',1);

1657: pay_balance_pkg.set_context('SOURCE_TEXT','N');
1658: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1659: l_curr_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1660: l_curr_haz_ter_all := l_curr_haz_saudi_ter + l_curr_haz_ter;
1661: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1662: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1663: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1664: l_curr_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1665: l_curr_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

Line 1662: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

1658: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1659: l_curr_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1660: l_curr_haz_ter_all := l_curr_haz_saudi_ter + l_curr_haz_ter;
1661: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1662: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1663: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1664: l_curr_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1665: l_curr_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1666: l_curr_haz_ann_saudi_new_ter := l_curr_ann_saudi_new_ter + l_curr_haz_saudi_new_ter;

Line 1663: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

1659: l_curr_haz_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1660: l_curr_haz_ter_all := l_curr_haz_saudi_ter + l_curr_haz_ter;
1661: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1662: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1663: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1664: l_curr_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1665: l_curr_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1666: l_curr_haz_ann_saudi_new_ter := l_curr_ann_saudi_new_ter + l_curr_haz_saudi_new_ter;
1667: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

Line 1664: l_curr_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);

1660: l_curr_haz_ter_all := l_curr_haz_saudi_ter + l_curr_haz_ter;
1661: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1662: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1663: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1664: l_curr_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1665: l_curr_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1666: l_curr_haz_ann_saudi_new_ter := l_curr_ann_saudi_new_ter + l_curr_haz_saudi_new_ter;
1667: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1668: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

Line 1665: l_curr_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

1661: pay_balance_pkg.set_context('SOURCE_NUMBER',1);
1662: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1663: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1664: l_curr_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1665: l_curr_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1666: l_curr_haz_ann_saudi_new_ter := l_curr_ann_saudi_new_ter + l_curr_haz_saudi_new_ter;
1667: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1668: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1669: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

Line 1667: pay_balance_pkg.set_context('SOURCE_NUMBER',2);

1663: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1664: l_curr_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1665: l_curr_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1666: l_curr_haz_ann_saudi_new_ter := l_curr_ann_saudi_new_ter + l_curr_haz_saudi_new_ter;
1667: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1668: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1669: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1670: l_curr_haz_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1671: l_curr_haz_new_ter_all := l_curr_haz_saudi_new_ter + l_curr_haz_new_ter;

Line 1668: pay_balance_pkg.set_context('SOURCE_TEXT','Y');

1664: l_curr_ann_saudi_new_ter := pay_balance_pkg.get_value(l_ann_month_db,null);
1665: l_curr_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1666: l_curr_haz_ann_saudi_new_ter := l_curr_ann_saudi_new_ter + l_curr_haz_saudi_new_ter;
1667: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1668: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1669: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1670: l_curr_haz_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1671: l_curr_haz_new_ter_all := l_curr_haz_saudi_new_ter + l_curr_haz_new_ter;
1672: l_tot_curr_ann_saudi := l_curr_ann_saudi + l_curr_ann_saudi_new + l_curr_ann_saudi_ter + l_curr_ann_saudi_new_ter;

Line 1669: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');

1665: l_curr_haz_saudi_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1666: l_curr_haz_ann_saudi_new_ter := l_curr_ann_saudi_new_ter + l_curr_haz_saudi_new_ter;
1667: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1668: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1669: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1670: l_curr_haz_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1671: l_curr_haz_new_ter_all := l_curr_haz_saudi_new_ter + l_curr_haz_new_ter;
1672: l_tot_curr_ann_saudi := l_curr_ann_saudi + l_curr_ann_saudi_new + l_curr_ann_saudi_ter + l_curr_ann_saudi_new_ter;
1673: l_tot_curr_haz_all := l_curr_haz_all + l_curr_haz_new_all + l_curr_haz_ter_all + l_curr_haz_new_ter_all;

Line 1670: l_curr_haz_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);

1666: l_curr_haz_ann_saudi_new_ter := l_curr_ann_saudi_new_ter + l_curr_haz_saudi_new_ter;
1667: pay_balance_pkg.set_context('SOURCE_NUMBER',2);
1668: pay_balance_pkg.set_context('SOURCE_TEXT','Y');
1669: pay_balance_pkg.set_context('SOURCE_TEXT2','Y');
1670: l_curr_haz_new_ter := pay_balance_pkg.get_value(l_haz_month_db,null);
1671: l_curr_haz_new_ter_all := l_curr_haz_saudi_new_ter + l_curr_haz_new_ter;
1672: l_tot_curr_ann_saudi := l_curr_ann_saudi + l_curr_ann_saudi_new + l_curr_ann_saudi_ter + l_curr_ann_saudi_new_ter;
1673: l_tot_curr_haz_all := l_curr_haz_all + l_curr_haz_new_all + l_curr_haz_ter_all + l_curr_haz_new_ter_all;
1674: l_tot_curr_haz_ann_saudi := l_curr_haz_ann_saudi + l_curr_haz_ann_saudi_new + l_curr_haz_ann_saudi_ter + l_curr_haz_ann_saudi_new_ter;

Line 2084: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);

2080: and u.user_entity_id = d.user_entity_id
2081: and u.legislation_code = 'SA'
2082: and u.business_group_id is null
2083: and u.creator_type = 'B';
2084: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2085: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));
2086: /*Fetch contribution of employees who got terminated after 28th of previous month*/
2087: open csr_get_leav_assact;
2088: loop

Line 2085: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));

2081: and u.legislation_code = 'SA'
2082: and u.business_group_id is null
2083: and u.creator_type = 'B';
2084: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2085: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_prev_mon_date));
2086: /*Fetch contribution of employees who got terminated after 28th of previous month*/
2087: open csr_get_leav_assact;
2088: loop
2089: fetch csr_get_leav_assact into rec_leav_assact;

Line 2093: l_assact_haz := pay_balance_pkg.get_value(l_gosi_haz_asg_tu_mth_db,rec_leav_assact.assignment_action_id);

2089: fetch csr_get_leav_assact into rec_leav_assact;
2090: exit when csr_get_leav_assact%notfound;
2091: l_assact_haz := 0;
2092: if nvl(l_hc_haz_ter_all,0) > 0 then
2093: l_assact_haz := pay_balance_pkg.get_value(l_gosi_haz_asg_tu_mth_db,rec_leav_assact.assignment_action_id);
2094: end if;
2095: l_sum_hazards_t := l_sum_hazards_t + l_assact_haz;
2096: if nvl(l_hc_ann_saudi_ter,0) > 0 then
2097: l_sum_saudi_annuities_t := l_sum_saudi_annuities_t +

Line 2098: (pay_balance_pkg.get_value(l_emp_gosi_ann_asg_ptd_db,rec_leav_assact.assignment_action_id));

2094: end if;
2095: l_sum_hazards_t := l_sum_hazards_t + l_assact_haz;
2096: if nvl(l_hc_ann_saudi_ter,0) > 0 then
2097: l_sum_saudi_annuities_t := l_sum_saudi_annuities_t +
2098: (pay_balance_pkg.get_value(l_emp_gosi_ann_asg_ptd_db,rec_leav_assact.assignment_action_id));
2099: end if;
2100: select count(*)
2101: into l_loc_nat
2102: from per_all_people_f

Line 2134: l_emp_annuity := pay_balance_pkg.get_value(l_emp_gosi_ann_asg_ptd_db,rec_l_ann_assact.assignment_action_id);

2130: open csr_saudi_l_ann_assact;
2131: loop
2132: fetch csr_saudi_l_ann_assact into rec_l_ann_assact;
2133: exit when csr_saudi_l_ann_assact%notfound;
2134: l_emp_annuity := pay_balance_pkg.get_value(l_emp_gosi_ann_asg_ptd_db,rec_l_ann_assact.assignment_action_id);
2135: l_tot_l_emp_annuity := l_tot_l_emp_annuity + l_emp_annuity;
2136: end loop;
2137: close csr_saudi_l_ann_assact;
2138: l_emp_annuity := 0;

Line 2144: l_emp_annuity := pay_balance_pkg.get_value(l_emp_gosi_ann_asg_ptd_db,rec_j_ann_assact.assignment_action_id);

2140: open csr_saudi_j_ann_assact;
2141: loop
2142: fetch csr_saudi_j_ann_assact into rec_j_ann_assact;
2143: exit when csr_saudi_j_ann_assact%notfound;
2144: l_emp_annuity := pay_balance_pkg.get_value(l_emp_gosi_ann_asg_ptd_db,rec_j_ann_assact.assignment_action_id);
2145: l_tot_j_emp_annuity := l_tot_j_emp_annuity + l_emp_annuity;
2146: end loop;
2147: close csr_saudi_j_ann_assact;
2148: end;

Line 3377: l_employee_monthly_cont := pay_balance_pkg.get_value(l_defined_balance_id, l_assignment_action_id);

3373: fetch get_assact_id into l_assignment_action_id;
3374: close get_assact_id;
3375: --get monthly contribution
3376: if l_assignment_action_id is not null then
3377: l_employee_monthly_cont := pay_balance_pkg.get_value(l_defined_balance_id, l_assignment_action_id);
3378: IF (l_employee_monthly_cont > to_number(l_upper_base)) THEN
3379: l_employee_monthly_cont := to_number(l_upper_base);
3380: ELSIF ( l_employee_monthly_cont < to_number(l_lower_base)) THEN
3381: l_employee_monthly_cont := to_number(l_lower_base);