APPS.PAY_GB_RTI_EYU dependencies on HR_DIRBAL

Line 970: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;

966: and pbd.legislation_code = 'GB';
967:
968: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
969: is
970: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
971:
972: BEGIN
973: hr_utility.set_location('Entering: '||l_proc,1);
974: l_context_lst(1).tax_unit_id :=NULL;

Line 1350: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;

1346: order by 2 desc;
1347:
1348: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
1349: is
1350: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
1351:
1352: cursor csr_reversal is
1353: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1354: where paa.assignment_action_id = p_last_asg_action_id

Line 1687: l_nia_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nia_able_id_run);

1683:
1684: if l_reversal is not null then
1685:
1686:
1687: l_nia_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nia_able_id_run);
1688: l_nia_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nia_e_id_run);
1689:
1690: l_nib_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_able_id_run);
1691: l_nib_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_e_id_run);

Line 1688: l_nia_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nia_e_id_run);

1684: if l_reversal is not null then
1685:
1686:
1687: l_nia_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nia_able_id_run);
1688: l_nia_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nia_e_id_run);
1689:
1690: l_nib_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_able_id_run);
1691: l_nib_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_e_id_run);
1692:

Line 1690: l_nib_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_able_id_run);

1686:
1687: l_nia_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nia_able_id_run);
1688: l_nia_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nia_e_id_run);
1689:
1690: l_nib_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_able_id_run);
1691: l_nib_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_e_id_run);
1692:
1693: l_nic_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_able_id_run);
1694: l_nic_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_e_id_run);

Line 1691: l_nib_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_e_id_run);

1687: l_nia_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nia_able_id_run);
1688: l_nia_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nia_e_id_run);
1689:
1690: l_nib_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_able_id_run);
1691: l_nib_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_e_id_run);
1692:
1693: l_nic_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_able_id_run);
1694: l_nic_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_e_id_run);
1695:

Line 1693: l_nic_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_able_id_run);

1689:
1690: l_nib_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_able_id_run);
1691: l_nib_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_e_id_run);
1692:
1693: l_nic_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_able_id_run);
1694: l_nic_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_e_id_run);
1695:
1696: l_nid_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_able_id_run);
1697: l_nid_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_id_run);

Line 1694: l_nic_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_e_id_run);

1690: l_nib_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_able_id_run);
1691: l_nib_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nib_e_id_run);
1692:
1693: l_nic_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_able_id_run);
1694: l_nic_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_e_id_run);
1695:
1696: l_nid_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_able_id_run);
1697: l_nid_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_id_run);
1698:

Line 1696: l_nid_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_able_id_run);

1692:
1693: l_nic_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_able_id_run);
1694: l_nic_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_e_id_run);
1695:
1696: l_nid_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_able_id_run);
1697: l_nid_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_id_run);
1698:
1699: l_nie_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_able_id_run);
1700: l_nie_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_e_id_run);

Line 1697: l_nid_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_id_run);

1693: l_nic_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_able_id_run);
1694: l_nic_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nic_e_id_run);
1695:
1696: l_nid_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_able_id_run);
1697: l_nid_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_id_run);
1698:
1699: l_nie_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_able_id_run);
1700: l_nie_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_e_id_run);
1701:

Line 1699: l_nie_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_able_id_run);

1695:
1696: l_nid_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_able_id_run);
1697: l_nid_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_id_run);
1698:
1699: l_nie_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_able_id_run);
1700: l_nie_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_e_id_run);
1701:
1702: l_nij_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_able_id_run);
1703: l_nij_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_e_id_run);

Line 1700: l_nie_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_e_id_run);

1696: l_nid_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_able_id_run);
1697: l_nid_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_id_run);
1698:
1699: l_nie_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_able_id_run);
1700: l_nie_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_e_id_run);
1701:
1702: l_nij_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_able_id_run);
1703: l_nij_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_e_id_run);
1704:

Line 1702: l_nij_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_able_id_run);

1698:
1699: l_nie_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_able_id_run);
1700: l_nie_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_e_id_run);
1701:
1702: l_nij_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_able_id_run);
1703: l_nij_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_e_id_run);
1704:
1705: l_nil_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nil_able_id_run);
1706: l_nil_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nil_e_id_run);

Line 1703: l_nij_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_e_id_run);

1699: l_nie_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_able_id_run);
1700: l_nie_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nie_e_id_run);
1701:
1702: l_nij_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_able_id_run);
1703: l_nij_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_e_id_run);
1704:
1705: l_nil_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nil_able_id_run);
1706: l_nil_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nil_e_id_run);
1707:

Line 1705: l_nil_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nil_able_id_run);

1701:
1702: l_nij_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_able_id_run);
1703: l_nij_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_e_id_run);
1704:
1705: l_nil_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nil_able_id_run);
1706: l_nil_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nil_e_id_run);
1707:
1708: end if;
1709:

Line 1706: l_nil_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nil_e_id_run);

1702: l_nij_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_able_id_run);
1703: l_nij_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nij_e_id_run);
1704:
1705: l_nil_able_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nil_able_id_run);
1706: l_nil_e_run := hr_dirbal.get_balance(l_last_chld_act_id, g_nil_e_id_run);
1707:
1708: end if;
1709:
1710: if NVL(l_aggr_archive_flag,'N') = 'Y' then

Line 1730: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_lel_id);

1726: hr_utility.trace('fetching NI A Total/Able balances');
1727: l_archive_tab_ni_det(already_a).assignment_id := p_asg_id;
1728: l_archive_tab_ni_det(already_a).action_info_category := 'GB_RTI_FPS_NI_DET';
1729: l_archive_tab_ni_det(already_a).act_info1 := 'A';
1730: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_lel_id);
1731: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_et_id);
1732: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uap_id);
1733: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uel_id);
1734: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_r_ytd_id);

Line 1731: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_et_id);

1727: l_archive_tab_ni_det(already_a).assignment_id := p_asg_id;
1728: l_archive_tab_ni_det(already_a).action_info_category := 'GB_RTI_FPS_NI_DET';
1729: l_archive_tab_ni_det(already_a).act_info1 := 'A';
1730: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_lel_id);
1731: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_et_id);
1732: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uap_id);
1733: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uel_id);
1734: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_r_ytd_id);
1735: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_e_ytd_id);

Line 1732: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uap_id);

1728: l_archive_tab_ni_det(already_a).action_info_category := 'GB_RTI_FPS_NI_DET';
1729: l_archive_tab_ni_det(already_a).act_info1 := 'A';
1730: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_lel_id);
1731: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_et_id);
1732: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uap_id);
1733: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uel_id);
1734: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_r_ytd_id);
1735: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_e_ytd_id);
1736: END IF;

Line 1733: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uel_id);

1729: l_archive_tab_ni_det(already_a).act_info1 := 'A';
1730: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_lel_id);
1731: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_et_id);
1732: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uap_id);
1733: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uel_id);
1734: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_r_ytd_id);
1735: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_e_ytd_id);
1736: END IF;
1737: IF (NVL(l_nib_total,0) <> 0 OR NVL(l_nib_able,0) <> 0 ) OR

Line 1734: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_r_ytd_id);

1730: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_lel_id);
1731: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_et_id);
1732: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uap_id);
1733: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uel_id);
1734: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_r_ytd_id);
1735: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_e_ytd_id);
1736: END IF;
1737: IF (NVL(l_nib_total,0) <> 0 OR NVL(l_nib_able,0) <> 0 ) OR
1738: ( l_reversal is not null and NVL(l_nib_able_run,0) <> 0 OR NVL(l_nib_e_run,0) <> 0) THEN

Line 1735: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_e_ytd_id);

1731: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_et_id);
1732: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uap_id);
1733: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_uel_id);
1734: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_r_ytd_id);
1735: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_e_ytd_id);
1736: END IF;
1737: IF (NVL(l_nib_total,0) <> 0 OR NVL(l_nib_able,0) <> 0 ) OR
1738: ( l_reversal is not null and NVL(l_nib_able_run,0) <> 0 OR NVL(l_nib_e_run,0) <> 0) THEN
1739:

Line 1748: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_lel_id);

1744: hr_utility.trace('fetching NI B Total/Able balances');
1745: l_archive_tab_ni_det(already_b).assignment_id := p_asg_id;
1746: l_archive_tab_ni_det(already_b).action_info_category := 'GB_RTI_FPS_NI_DET';
1747: l_archive_tab_ni_det(already_b).act_info1 := 'B';
1748: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_lel_id);
1749: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_et_id);
1750: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uap_id);
1751: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uel_id);
1752: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_r_ytd_id);

Line 1749: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_et_id);

1745: l_archive_tab_ni_det(already_b).assignment_id := p_asg_id;
1746: l_archive_tab_ni_det(already_b).action_info_category := 'GB_RTI_FPS_NI_DET';
1747: l_archive_tab_ni_det(already_b).act_info1 := 'B';
1748: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_lel_id);
1749: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_et_id);
1750: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uap_id);
1751: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uel_id);
1752: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_r_ytd_id);
1753: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_e_ytd_id);

Line 1750: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uap_id);

1746: l_archive_tab_ni_det(already_b).action_info_category := 'GB_RTI_FPS_NI_DET';
1747: l_archive_tab_ni_det(already_b).act_info1 := 'B';
1748: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_lel_id);
1749: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_et_id);
1750: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uap_id);
1751: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uel_id);
1752: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_r_ytd_id);
1753: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_e_ytd_id);
1754: END IF;

Line 1751: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uel_id);

1747: l_archive_tab_ni_det(already_b).act_info1 := 'B';
1748: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_lel_id);
1749: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_et_id);
1750: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uap_id);
1751: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uel_id);
1752: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_r_ytd_id);
1753: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_e_ytd_id);
1754: END IF;
1755: IF (NVL(l_nic_total,0) <> 0 OR NVL(l_nic_able,0) <> 0 ) OR

Line 1752: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_r_ytd_id);

1748: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_lel_id);
1749: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_et_id);
1750: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uap_id);
1751: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uel_id);
1752: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_r_ytd_id);
1753: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_e_ytd_id);
1754: END IF;
1755: IF (NVL(l_nic_total,0) <> 0 OR NVL(l_nic_able,0) <> 0 ) OR
1756: ( l_reversal is not null and NVL(l_nic_able_run,0) <> 0 OR NVL(l_nic_e_run,0) <> 0) THEN

Line 1753: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_e_ytd_id);

1749: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_et_id);
1750: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uap_id);
1751: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_uel_id);
1752: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_r_ytd_id);
1753: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_e_ytd_id);
1754: END IF;
1755: IF (NVL(l_nic_total,0) <> 0 OR NVL(l_nic_able,0) <> 0 ) OR
1756: ( l_reversal is not null and NVL(l_nic_able_run,0) <> 0 OR NVL(l_nic_e_run,0) <> 0) THEN
1757: IF already_c = -1 THEN

Line 1765: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_lel_id);

1761: hr_utility.trace('fetching NI C Total/Able balances');
1762: l_archive_tab_ni_det(already_c).assignment_id := p_asg_id;
1763: l_archive_tab_ni_det(already_c).action_info_category := 'GB_RTI_FPS_NI_DET';
1764: l_archive_tab_ni_det(already_c).act_info1 := 'C';
1765: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_lel_id);
1766: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_et_id);
1767: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uap_id);
1768: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uel_id);
1769: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_r_ytd_id);

Line 1766: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_et_id);

1762: l_archive_tab_ni_det(already_c).assignment_id := p_asg_id;
1763: l_archive_tab_ni_det(already_c).action_info_category := 'GB_RTI_FPS_NI_DET';
1764: l_archive_tab_ni_det(already_c).act_info1 := 'C';
1765: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_lel_id);
1766: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_et_id);
1767: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uap_id);
1768: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uel_id);
1769: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_r_ytd_id);
1770: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_e_ytd_id);

Line 1767: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uap_id);

1763: l_archive_tab_ni_det(already_c).action_info_category := 'GB_RTI_FPS_NI_DET';
1764: l_archive_tab_ni_det(already_c).act_info1 := 'C';
1765: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_lel_id);
1766: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_et_id);
1767: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uap_id);
1768: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uel_id);
1769: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_r_ytd_id);
1770: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_e_ytd_id);
1771: END IF;

Line 1768: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uel_id);

1764: l_archive_tab_ni_det(already_c).act_info1 := 'C';
1765: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_lel_id);
1766: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_et_id);
1767: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uap_id);
1768: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uel_id);
1769: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_r_ytd_id);
1770: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_e_ytd_id);
1771: END IF;
1772: IF (NVL(l_nid_total,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) OR

Line 1769: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_r_ytd_id);

1765: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_lel_id);
1766: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_et_id);
1767: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uap_id);
1768: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uel_id);
1769: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_r_ytd_id);
1770: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_e_ytd_id);
1771: END IF;
1772: IF (NVL(l_nid_total,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) OR
1773: ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_run,0) <> 0) THEN

Line 1770: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_e_ytd_id);

1766: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_et_id);
1767: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uap_id);
1768: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_uel_id);
1769: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_r_ytd_id);
1770: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_e_ytd_id);
1771: END IF;
1772: IF (NVL(l_nid_total,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) OR
1773: ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_run,0) <> 0) THEN
1774: IF already_d = -1 THEN

Line 1782: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_lel_id);

1778: hr_utility.trace('fetching NI D Total/Able balances');
1779: l_archive_tab_ni_det(already_d).assignment_id := p_asg_id;
1780: l_archive_tab_ni_det(already_d).action_info_category := 'GB_RTI_FPS_NI_DET';
1781: l_archive_tab_ni_det(already_d).act_info1 := 'D';
1782: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_lel_id);
1783: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_et_id);
1784: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uap_id);
1785: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uel_id);
1786: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_r_ytd_id);

Line 1783: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_et_id);

1779: l_archive_tab_ni_det(already_d).assignment_id := p_asg_id;
1780: l_archive_tab_ni_det(already_d).action_info_category := 'GB_RTI_FPS_NI_DET';
1781: l_archive_tab_ni_det(already_d).act_info1 := 'D';
1782: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_lel_id);
1783: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_et_id);
1784: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uap_id);
1785: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uel_id);
1786: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_r_ytd_id);
1787: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_e_ytd_id);

Line 1784: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uap_id);

1780: l_archive_tab_ni_det(already_d).action_info_category := 'GB_RTI_FPS_NI_DET';
1781: l_archive_tab_ni_det(already_d).act_info1 := 'D';
1782: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_lel_id);
1783: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_et_id);
1784: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uap_id);
1785: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uel_id);
1786: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_r_ytd_id);
1787: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_e_ytd_id);
1788: END IF;

Line 1785: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uel_id);

1781: l_archive_tab_ni_det(already_d).act_info1 := 'D';
1782: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_lel_id);
1783: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_et_id);
1784: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uap_id);
1785: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uel_id);
1786: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_r_ytd_id);
1787: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_e_ytd_id);
1788: END IF;
1789: IF (NVL(l_nie_total,0) <> 0 OR NVL(l_nie_able,0) <> 0 ) OR

Line 1786: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_r_ytd_id);

1782: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_lel_id);
1783: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_et_id);
1784: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uap_id);
1785: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uel_id);
1786: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_r_ytd_id);
1787: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_e_ytd_id);
1788: END IF;
1789: IF (NVL(l_nie_total,0) <> 0 OR NVL(l_nie_able,0) <> 0 ) OR
1790: ( l_reversal is not null and NVL(l_nie_able_run,0) <> 0 OR NVL(l_nie_e_run,0) <> 0) THEN

Line 1787: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_e_ytd_id);

1783: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_et_id);
1784: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uap_id);
1785: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_uel_id);
1786: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_r_ytd_id);
1787: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_per_nid_e_ytd_id);
1788: END IF;
1789: IF (NVL(l_nie_total,0) <> 0 OR NVL(l_nie_able,0) <> 0 ) OR
1790: ( l_reversal is not null and NVL(l_nie_able_run,0) <> 0 OR NVL(l_nie_e_run,0) <> 0) THEN
1791: IF already_e = -1 THEN

Line 1799: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_lel_id);

1795: hr_utility.trace('fetching NI E Total/Able balances');
1796: l_archive_tab_ni_det(already_e).assignment_id := p_asg_id;
1797: l_archive_tab_ni_det(already_e).action_info_category := 'GB_RTI_FPS_NI_DET';
1798: l_archive_tab_ni_det(already_e).act_info1 := 'E';
1799: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_lel_id);
1800: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_et_id);
1801: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uap_id);
1802: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uel_id);
1803: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_r_ytd_id);

Line 1800: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_et_id);

1796: l_archive_tab_ni_det(already_e).assignment_id := p_asg_id;
1797: l_archive_tab_ni_det(already_e).action_info_category := 'GB_RTI_FPS_NI_DET';
1798: l_archive_tab_ni_det(already_e).act_info1 := 'E';
1799: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_lel_id);
1800: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_et_id);
1801: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uap_id);
1802: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uel_id);
1803: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_r_ytd_id);
1804: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_e_ytd_id);

Line 1801: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uap_id);

1797: l_archive_tab_ni_det(already_e).action_info_category := 'GB_RTI_FPS_NI_DET';
1798: l_archive_tab_ni_det(already_e).act_info1 := 'E';
1799: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_lel_id);
1800: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_et_id);
1801: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uap_id);
1802: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uel_id);
1803: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_r_ytd_id);
1804: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_e_ytd_id);
1805: END IF;

Line 1802: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uel_id);

1798: l_archive_tab_ni_det(already_e).act_info1 := 'E';
1799: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_lel_id);
1800: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_et_id);
1801: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uap_id);
1802: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uel_id);
1803: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_r_ytd_id);
1804: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_e_ytd_id);
1805: END IF;
1806: IF (NVL(l_nij_total,0) <> 0 OR NVL(l_nij_able,0) <> 0 ) OR

Line 1803: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_r_ytd_id);

1799: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_lel_id);
1800: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_et_id);
1801: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uap_id);
1802: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uel_id);
1803: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_r_ytd_id);
1804: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_e_ytd_id);
1805: END IF;
1806: IF (NVL(l_nij_total,0) <> 0 OR NVL(l_nij_able,0) <> 0 ) OR
1807: ( l_reversal is not null and NVL(l_nij_able_run,0) <> 0 OR NVL(l_nij_e_run,0) <> 0) THEN

Line 1804: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_e_ytd_id);

1800: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_et_id);
1801: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uap_id);
1802: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_uel_id);
1803: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_r_ytd_id);
1804: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_e_ytd_id);
1805: END IF;
1806: IF (NVL(l_nij_total,0) <> 0 OR NVL(l_nij_able,0) <> 0 ) OR
1807: ( l_reversal is not null and NVL(l_nij_able_run,0) <> 0 OR NVL(l_nij_e_run,0) <> 0) THEN
1808: IF already_j = -1 THEN

Line 1816: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_lel_id);

1812: hr_utility.trace('fetching NI J Total/Able balances');
1813: l_archive_tab_ni_det(already_j).assignment_id := p_asg_id;
1814: l_archive_tab_ni_det(already_j).action_info_category := 'GB_RTI_FPS_NI_DET';
1815: l_archive_tab_ni_det(already_j).act_info1 := 'J';
1816: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_lel_id);
1817: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_et_id);
1818: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uap_id);
1819: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uel_id);
1820: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_r_ytd_id);

Line 1817: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_et_id);

1813: l_archive_tab_ni_det(already_j).assignment_id := p_asg_id;
1814: l_archive_tab_ni_det(already_j).action_info_category := 'GB_RTI_FPS_NI_DET';
1815: l_archive_tab_ni_det(already_j).act_info1 := 'J';
1816: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_lel_id);
1817: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_et_id);
1818: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uap_id);
1819: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uel_id);
1820: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_r_ytd_id);
1821: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_e_ytd_id);

Line 1818: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uap_id);

1814: l_archive_tab_ni_det(already_j).action_info_category := 'GB_RTI_FPS_NI_DET';
1815: l_archive_tab_ni_det(already_j).act_info1 := 'J';
1816: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_lel_id);
1817: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_et_id);
1818: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uap_id);
1819: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uel_id);
1820: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_r_ytd_id);
1821: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_e_ytd_id);
1822: END IF;

Line 1819: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uel_id);

1815: l_archive_tab_ni_det(already_j).act_info1 := 'J';
1816: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_lel_id);
1817: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_et_id);
1818: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uap_id);
1819: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uel_id);
1820: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_r_ytd_id);
1821: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_e_ytd_id);
1822: END IF;
1823: IF (NVL(l_nil_total,0) <> 0 OR NVL(l_nil_able,0) <> 0 ) OR

Line 1820: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_r_ytd_id);

1816: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_lel_id);
1817: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_et_id);
1818: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uap_id);
1819: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uel_id);
1820: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_r_ytd_id);
1821: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_e_ytd_id);
1822: END IF;
1823: IF (NVL(l_nil_total,0) <> 0 OR NVL(l_nil_able,0) <> 0 ) OR
1824: ( l_reversal is not null and NVL(l_nil_able_run,0) <> 0 OR NVL(l_nil_e_run,0) <> 0) THEN

Line 1821: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_e_ytd_id);

1817: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_et_id);
1818: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uap_id);
1819: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_uel_id);
1820: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_r_ytd_id);
1821: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_e_ytd_id);
1822: END IF;
1823: IF (NVL(l_nil_total,0) <> 0 OR NVL(l_nil_able,0) <> 0 ) OR
1824: ( l_reversal is not null and NVL(l_nil_able_run,0) <> 0 OR NVL(l_nil_e_run,0) <> 0) THEN
1825: IF already_l = -1 THEN

Line 1833: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_lel_id);

1829: hr_utility.trace('fetching NI L Total/Able balances');
1830: l_archive_tab_ni_det(already_l).assignment_id := p_asg_id;
1831: l_archive_tab_ni_det(already_l).action_info_category := 'GB_RTI_FPS_NI_DET';
1832: l_archive_tab_ni_det(already_l).act_info1 := 'L';
1833: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_lel_id);
1834: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_et_id);
1835: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uap_id);
1836: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uel_id);
1837: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_r_ytd_id);

Line 1834: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_et_id);

1830: l_archive_tab_ni_det(already_l).assignment_id := p_asg_id;
1831: l_archive_tab_ni_det(already_l).action_info_category := 'GB_RTI_FPS_NI_DET';
1832: l_archive_tab_ni_det(already_l).act_info1 := 'L';
1833: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_lel_id);
1834: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_et_id);
1835: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uap_id);
1836: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uel_id);
1837: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_r_ytd_id);
1838: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_e_ytd_id);

Line 1835: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uap_id);

1831: l_archive_tab_ni_det(already_l).action_info_category := 'GB_RTI_FPS_NI_DET';
1832: l_archive_tab_ni_det(already_l).act_info1 := 'L';
1833: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_lel_id);
1834: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_et_id);
1835: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uap_id);
1836: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uel_id);
1837: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_r_ytd_id);
1838: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_e_ytd_id);
1839: END IF;

Line 1836: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uel_id);

1832: l_archive_tab_ni_det(already_l).act_info1 := 'L';
1833: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_lel_id);
1834: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_et_id);
1835: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uap_id);
1836: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uel_id);
1837: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_r_ytd_id);
1838: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_e_ytd_id);
1839: END IF;
1840:

Line 1837: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_r_ytd_id);

1833: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_lel_id);
1834: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_et_id);
1835: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uap_id);
1836: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uel_id);
1837: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_r_ytd_id);
1838: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_e_ytd_id);
1839: END IF;
1840:
1841: else --Aggregation else

Line 1838: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_e_ytd_id);

1834: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_et_id);
1835: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uap_id);
1836: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_uel_id);
1837: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_r_ytd_id);
1838: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_e_ytd_id);
1839: END IF;
1840:
1841: else --Aggregation else
1842: hr_utility.trace('fetching NI balances');

Line 1854: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_lel_id);

1850: hr_utility.trace('fetching NI A Total/Able balances');
1851: l_archive_tab_ni_det(already_a).assignment_id := p_asg_id;
1852: l_archive_tab_ni_det(already_a).action_info_category := 'GB_RTI_FPS_NI_DET';
1853: l_archive_tab_ni_det(already_a).act_info1 := 'A';
1854: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_lel_id);
1855: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_et_id);
1856: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uap_id);
1857: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uel_id);
1858: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_r_ytd_id);

Line 1855: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_et_id);

1851: l_archive_tab_ni_det(already_a).assignment_id := p_asg_id;
1852: l_archive_tab_ni_det(already_a).action_info_category := 'GB_RTI_FPS_NI_DET';
1853: l_archive_tab_ni_det(already_a).act_info1 := 'A';
1854: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_lel_id);
1855: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_et_id);
1856: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uap_id);
1857: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uel_id);
1858: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_r_ytd_id);
1859: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_e_ytd_id);

Line 1856: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uap_id);

1852: l_archive_tab_ni_det(already_a).action_info_category := 'GB_RTI_FPS_NI_DET';
1853: l_archive_tab_ni_det(already_a).act_info1 := 'A';
1854: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_lel_id);
1855: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_et_id);
1856: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uap_id);
1857: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uel_id);
1858: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_r_ytd_id);
1859: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_e_ytd_id);
1860: END IF;

Line 1857: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uel_id);

1853: l_archive_tab_ni_det(already_a).act_info1 := 'A';
1854: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_lel_id);
1855: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_et_id);
1856: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uap_id);
1857: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uel_id);
1858: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_r_ytd_id);
1859: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_e_ytd_id);
1860: END IF;
1861: IF (NVL(l_nib_total,0) <> 0 OR NVL(l_nib_able,0) <> 0 ) OR

Line 1858: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_r_ytd_id);

1854: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_lel_id);
1855: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_et_id);
1856: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uap_id);
1857: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uel_id);
1858: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_r_ytd_id);
1859: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_e_ytd_id);
1860: END IF;
1861: IF (NVL(l_nib_total,0) <> 0 OR NVL(l_nib_able,0) <> 0 ) OR
1862: ( l_reversal is not null and NVL(l_nib_able_run,0) <> 0 OR NVL(l_nib_e_run,0) <> 0) THEN

Line 1859: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_e_ytd_id);

1855: l_archive_tab_ni_det(already_a).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_et_id);
1856: l_archive_tab_ni_det(already_a).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uap_id);
1857: l_archive_tab_ni_det(already_a).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_uel_id);
1858: l_archive_tab_ni_det(already_a).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_r_ytd_id);
1859: l_archive_tab_ni_det(already_a).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_e_ytd_id);
1860: END IF;
1861: IF (NVL(l_nib_total,0) <> 0 OR NVL(l_nib_able,0) <> 0 ) OR
1862: ( l_reversal is not null and NVL(l_nib_able_run,0) <> 0 OR NVL(l_nib_e_run,0) <> 0) THEN
1863: IF already_b = -1 THEN

Line 1871: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_lel_id);

1867: hr_utility.trace('fetching NI B Total/Able balances');
1868: l_archive_tab_ni_det(already_b).assignment_id := p_asg_id;
1869: l_archive_tab_ni_det(already_b).action_info_category := 'GB_RTI_FPS_NI_DET';
1870: l_archive_tab_ni_det(already_b).act_info1 := 'B';
1871: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_lel_id);
1872: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_et_id);
1873: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uap_id);
1874: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uel_id);
1875: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_r_ytd_id);

Line 1872: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_et_id);

1868: l_archive_tab_ni_det(already_b).assignment_id := p_asg_id;
1869: l_archive_tab_ni_det(already_b).action_info_category := 'GB_RTI_FPS_NI_DET';
1870: l_archive_tab_ni_det(already_b).act_info1 := 'B';
1871: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_lel_id);
1872: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_et_id);
1873: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uap_id);
1874: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uel_id);
1875: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_r_ytd_id);
1876: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_e_ytd_id);

Line 1873: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uap_id);

1869: l_archive_tab_ni_det(already_b).action_info_category := 'GB_RTI_FPS_NI_DET';
1870: l_archive_tab_ni_det(already_b).act_info1 := 'B';
1871: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_lel_id);
1872: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_et_id);
1873: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uap_id);
1874: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uel_id);
1875: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_r_ytd_id);
1876: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_e_ytd_id);
1877: END IF;

Line 1874: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uel_id);

1870: l_archive_tab_ni_det(already_b).act_info1 := 'B';
1871: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_lel_id);
1872: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_et_id);
1873: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uap_id);
1874: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uel_id);
1875: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_r_ytd_id);
1876: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_e_ytd_id);
1877: END IF;
1878: IF (NVL(l_nic_total,0) <> 0 OR NVL(l_nic_able,0) <> 0 ) OR

Line 1875: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_r_ytd_id);

1871: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_lel_id);
1872: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_et_id);
1873: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uap_id);
1874: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uel_id);
1875: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_r_ytd_id);
1876: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_e_ytd_id);
1877: END IF;
1878: IF (NVL(l_nic_total,0) <> 0 OR NVL(l_nic_able,0) <> 0 ) OR
1879: ( l_reversal is not null and NVL(l_nic_able_run,0) <> 0 OR NVL(l_nic_e_run,0) <> 0) THEN

Line 1876: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_e_ytd_id);

1872: l_archive_tab_ni_det(already_b).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_et_id);
1873: l_archive_tab_ni_det(already_b).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uap_id);
1874: l_archive_tab_ni_det(already_b).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_uel_id);
1875: l_archive_tab_ni_det(already_b).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_r_ytd_id);
1876: l_archive_tab_ni_det(already_b).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_e_ytd_id);
1877: END IF;
1878: IF (NVL(l_nic_total,0) <> 0 OR NVL(l_nic_able,0) <> 0 ) OR
1879: ( l_reversal is not null and NVL(l_nic_able_run,0) <> 0 OR NVL(l_nic_e_run,0) <> 0) THEN
1880: IF already_c = -1 THEN

Line 1888: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_lel_id);

1884: hr_utility.trace('fetching NI C Total/Able balances');
1885: l_archive_tab_ni_det(already_c).assignment_id := p_asg_id;
1886: l_archive_tab_ni_det(already_c).action_info_category := 'GB_RTI_FPS_NI_DET';
1887: l_archive_tab_ni_det(already_c).act_info1 := 'C';
1888: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_lel_id);
1889: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_et_id);
1890: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uap_id);
1891: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uel_id);
1892: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_r_ytd_id);

Line 1889: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_et_id);

1885: l_archive_tab_ni_det(already_c).assignment_id := p_asg_id;
1886: l_archive_tab_ni_det(already_c).action_info_category := 'GB_RTI_FPS_NI_DET';
1887: l_archive_tab_ni_det(already_c).act_info1 := 'C';
1888: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_lel_id);
1889: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_et_id);
1890: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uap_id);
1891: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uel_id);
1892: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_r_ytd_id);
1893: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_e_ytd_id);

Line 1890: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uap_id);

1886: l_archive_tab_ni_det(already_c).action_info_category := 'GB_RTI_FPS_NI_DET';
1887: l_archive_tab_ni_det(already_c).act_info1 := 'C';
1888: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_lel_id);
1889: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_et_id);
1890: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uap_id);
1891: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uel_id);
1892: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_r_ytd_id);
1893: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_e_ytd_id);
1894: END IF;

Line 1891: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uel_id);

1887: l_archive_tab_ni_det(already_c).act_info1 := 'C';
1888: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_lel_id);
1889: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_et_id);
1890: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uap_id);
1891: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uel_id);
1892: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_r_ytd_id);
1893: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_e_ytd_id);
1894: END IF;
1895: IF (NVL(l_nid_total,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) OR

Line 1892: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_r_ytd_id);

1888: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_lel_id);
1889: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_et_id);
1890: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uap_id);
1891: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uel_id);
1892: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_r_ytd_id);
1893: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_e_ytd_id);
1894: END IF;
1895: IF (NVL(l_nid_total,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) OR
1896: ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_run,0) <> 0) THEN

Line 1893: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_e_ytd_id);

1889: l_archive_tab_ni_det(already_c).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_et_id);
1890: l_archive_tab_ni_det(already_c).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uap_id);
1891: l_archive_tab_ni_det(already_c).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_uel_id);
1892: l_archive_tab_ni_det(already_c).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_r_ytd_id);
1893: l_archive_tab_ni_det(already_c).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_e_ytd_id);
1894: END IF;
1895: IF (NVL(l_nid_total,0) <> 0 OR NVL(l_nid_able,0) <> 0 ) OR
1896: ( l_reversal is not null and NVL(l_nid_able_run,0) <> 0 OR NVL(l_nid_e_run,0) <> 0) THEN
1897: IF already_d = -1 THEN

Line 1905: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_lel_id);

1901: hr_utility.trace('fetching NI D Total/Able balances');
1902: l_archive_tab_ni_det(already_d).assignment_id := p_asg_id;
1903: l_archive_tab_ni_det(already_d).action_info_category := 'GB_RTI_FPS_NI_DET';
1904: l_archive_tab_ni_det(already_d).act_info1 := 'D';
1905: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_lel_id);
1906: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_et_id);
1907: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uap_id);
1908: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uel_id);
1909: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_r_ytd_id);

Line 1906: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_et_id);

1902: l_archive_tab_ni_det(already_d).assignment_id := p_asg_id;
1903: l_archive_tab_ni_det(already_d).action_info_category := 'GB_RTI_FPS_NI_DET';
1904: l_archive_tab_ni_det(already_d).act_info1 := 'D';
1905: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_lel_id);
1906: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_et_id);
1907: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uap_id);
1908: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uel_id);
1909: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_r_ytd_id);
1910: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_ytd_id);

Line 1907: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uap_id);

1903: l_archive_tab_ni_det(already_d).action_info_category := 'GB_RTI_FPS_NI_DET';
1904: l_archive_tab_ni_det(already_d).act_info1 := 'D';
1905: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_lel_id);
1906: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_et_id);
1907: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uap_id);
1908: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uel_id);
1909: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_r_ytd_id);
1910: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_ytd_id);
1911: END IF;

Line 1908: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uel_id);

1904: l_archive_tab_ni_det(already_d).act_info1 := 'D';
1905: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_lel_id);
1906: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_et_id);
1907: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uap_id);
1908: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uel_id);
1909: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_r_ytd_id);
1910: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_ytd_id);
1911: END IF;
1912: IF (NVL(l_nie_total,0) <> 0 OR NVL(l_nie_able,0) <> 0 ) OR

Line 1909: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_r_ytd_id);

1905: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_lel_id);
1906: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_et_id);
1907: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uap_id);
1908: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uel_id);
1909: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_r_ytd_id);
1910: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_ytd_id);
1911: END IF;
1912: IF (NVL(l_nie_total,0) <> 0 OR NVL(l_nie_able,0) <> 0 ) OR
1913: ( l_reversal is not null and NVL(l_nie_able_run,0) <> 0 OR NVL(l_nie_e_run,0) <> 0) THEN

Line 1910: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_ytd_id);

1906: l_archive_tab_ni_det(already_d).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_et_id);
1907: l_archive_tab_ni_det(already_d).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uap_id);
1908: l_archive_tab_ni_det(already_d).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_uel_id);
1909: l_archive_tab_ni_det(already_d).act_info7 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_r_ytd_id);
1910: l_archive_tab_ni_det(already_d).act_info8 := 100 * hr_dirbal.get_balance(l_last_chld_act_id, g_nid_e_ytd_id);
1911: END IF;
1912: IF (NVL(l_nie_total,0) <> 0 OR NVL(l_nie_able,0) <> 0 ) OR
1913: ( l_reversal is not null and NVL(l_nie_able_run,0) <> 0 OR NVL(l_nie_e_run,0) <> 0) THEN
1914: IF already_e = -1 THEN

Line 1922: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_lel_id);

1918: hr_utility.trace('fetching NI E Total/Able balances');
1919: l_archive_tab_ni_det(already_e).assignment_id := p_asg_id;
1920: l_archive_tab_ni_det(already_e).action_info_category := 'GB_RTI_FPS_NI_DET';
1921: l_archive_tab_ni_det(already_e).act_info1 := 'E';
1922: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_lel_id);
1923: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_et_id);
1924: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uap_id);
1925: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uel_id);
1926: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_r_ytd_id);

Line 1923: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_et_id);

1919: l_archive_tab_ni_det(already_e).assignment_id := p_asg_id;
1920: l_archive_tab_ni_det(already_e).action_info_category := 'GB_RTI_FPS_NI_DET';
1921: l_archive_tab_ni_det(already_e).act_info1 := 'E';
1922: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_lel_id);
1923: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_et_id);
1924: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uap_id);
1925: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uel_id);
1926: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_r_ytd_id);
1927: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_e_ytd_id);

Line 1924: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uap_id);

1920: l_archive_tab_ni_det(already_e).action_info_category := 'GB_RTI_FPS_NI_DET';
1921: l_archive_tab_ni_det(already_e).act_info1 := 'E';
1922: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_lel_id);
1923: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_et_id);
1924: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uap_id);
1925: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uel_id);
1926: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_r_ytd_id);
1927: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_e_ytd_id);
1928: END IF;

Line 1925: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uel_id);

1921: l_archive_tab_ni_det(already_e).act_info1 := 'E';
1922: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_lel_id);
1923: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_et_id);
1924: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uap_id);
1925: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uel_id);
1926: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_r_ytd_id);
1927: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_e_ytd_id);
1928: END IF;
1929: IF (NVL(l_nij_total,0) <> 0 OR NVL(l_nij_able,0) <> 0 ) OR

Line 1926: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_r_ytd_id);

1922: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_lel_id);
1923: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_et_id);
1924: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uap_id);
1925: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uel_id);
1926: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_r_ytd_id);
1927: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_e_ytd_id);
1928: END IF;
1929: IF (NVL(l_nij_total,0) <> 0 OR NVL(l_nij_able,0) <> 0 ) OR
1930: ( l_reversal is not null and NVL(l_nij_able_run,0) <> 0 OR NVL(l_nij_e_run,0) <> 0) THEN

Line 1927: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_e_ytd_id);

1923: l_archive_tab_ni_det(already_e).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_et_id);
1924: l_archive_tab_ni_det(already_e).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uap_id);
1925: l_archive_tab_ni_det(already_e).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_uel_id);
1926: l_archive_tab_ni_det(already_e).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_r_ytd_id);
1927: l_archive_tab_ni_det(already_e).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_e_ytd_id);
1928: END IF;
1929: IF (NVL(l_nij_total,0) <> 0 OR NVL(l_nij_able,0) <> 0 ) OR
1930: ( l_reversal is not null and NVL(l_nij_able_run,0) <> 0 OR NVL(l_nij_e_run,0) <> 0) THEN
1931: IF already_j = -1 THEN

Line 1939: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_lel_id);

1935: hr_utility.trace('fetching NI J Total/Able balances');
1936: l_archive_tab_ni_det(already_j).assignment_id := p_asg_id;
1937: l_archive_tab_ni_det(already_j).action_info_category := 'GB_RTI_FPS_NI_DET';
1938: l_archive_tab_ni_det(already_j).act_info1 := 'J';
1939: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_lel_id);
1940: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_et_id);
1941: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uap_id);
1942: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uel_id);
1943: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_r_ytd_id);

Line 1940: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_et_id);

1936: l_archive_tab_ni_det(already_j).assignment_id := p_asg_id;
1937: l_archive_tab_ni_det(already_j).action_info_category := 'GB_RTI_FPS_NI_DET';
1938: l_archive_tab_ni_det(already_j).act_info1 := 'J';
1939: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_lel_id);
1940: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_et_id);
1941: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uap_id);
1942: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uel_id);
1943: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_r_ytd_id);
1944: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_e_ytd_id);

Line 1941: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uap_id);

1937: l_archive_tab_ni_det(already_j).action_info_category := 'GB_RTI_FPS_NI_DET';
1938: l_archive_tab_ni_det(already_j).act_info1 := 'J';
1939: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_lel_id);
1940: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_et_id);
1941: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uap_id);
1942: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uel_id);
1943: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_r_ytd_id);
1944: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_e_ytd_id);
1945: END IF;

Line 1942: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uel_id);

1938: l_archive_tab_ni_det(already_j).act_info1 := 'J';
1939: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_lel_id);
1940: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_et_id);
1941: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uap_id);
1942: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uel_id);
1943: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_r_ytd_id);
1944: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_e_ytd_id);
1945: END IF;
1946: IF (NVL(l_nil_total,0) <> 0 OR NVL(l_nil_able,0) <> 0 ) OR

Line 1943: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_r_ytd_id);

1939: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_lel_id);
1940: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_et_id);
1941: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uap_id);
1942: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uel_id);
1943: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_r_ytd_id);
1944: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_e_ytd_id);
1945: END IF;
1946: IF (NVL(l_nil_total,0) <> 0 OR NVL(l_nil_able,0) <> 0 ) OR
1947: ( l_reversal is not null and NVL(l_nil_able_run,0) <> 0 OR NVL(l_nil_e_run,0) <> 0) THEN

Line 1944: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_e_ytd_id);

1940: l_archive_tab_ni_det(already_j).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_et_id);
1941: l_archive_tab_ni_det(already_j).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uap_id);
1942: l_archive_tab_ni_det(already_j).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_uel_id);
1943: l_archive_tab_ni_det(already_j).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_r_ytd_id);
1944: l_archive_tab_ni_det(already_j).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_e_ytd_id);
1945: END IF;
1946: IF (NVL(l_nil_total,0) <> 0 OR NVL(l_nil_able,0) <> 0 ) OR
1947: ( l_reversal is not null and NVL(l_nil_able_run,0) <> 0 OR NVL(l_nil_e_run,0) <> 0) THEN
1948: IF already_l = -1 THEN

Line 1956: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_lel_id);

1952: hr_utility.trace('fetching NI L Total/Able balances');
1953: l_archive_tab_ni_det(already_l).assignment_id := p_asg_id;
1954: l_archive_tab_ni_det(already_l).action_info_category := 'GB_RTI_FPS_NI_DET';
1955: l_archive_tab_ni_det(already_l).act_info1 := 'L';
1956: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_lel_id);
1957: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_et_id);
1958: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uap_id);
1959: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uel_id);
1960: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_r_ytd_id);

Line 1957: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_et_id);

1953: l_archive_tab_ni_det(already_l).assignment_id := p_asg_id;
1954: l_archive_tab_ni_det(already_l).action_info_category := 'GB_RTI_FPS_NI_DET';
1955: l_archive_tab_ni_det(already_l).act_info1 := 'L';
1956: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_lel_id);
1957: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_et_id);
1958: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uap_id);
1959: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uel_id);
1960: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_r_ytd_id);
1961: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_e_ytd_id);

Line 1958: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uap_id);

1954: l_archive_tab_ni_det(already_l).action_info_category := 'GB_RTI_FPS_NI_DET';
1955: l_archive_tab_ni_det(already_l).act_info1 := 'L';
1956: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_lel_id);
1957: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_et_id);
1958: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uap_id);
1959: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uel_id);
1960: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_r_ytd_id);
1961: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_e_ytd_id);
1962: END IF;

Line 1959: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uel_id);

1955: l_archive_tab_ni_det(already_l).act_info1 := 'L';
1956: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_lel_id);
1957: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_et_id);
1958: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uap_id);
1959: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uel_id);
1960: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_r_ytd_id);
1961: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_e_ytd_id);
1962: END IF;
1963:

Line 1960: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_r_ytd_id);

1956: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_lel_id);
1957: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_et_id);
1958: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uap_id);
1959: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uel_id);
1960: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_r_ytd_id);
1961: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_e_ytd_id);
1962: END IF;
1963:
1964: END IF; --Aggregation End

Line 1961: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_e_ytd_id);

1957: l_archive_tab_ni_det(already_l).act_info4 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_et_id);
1958: l_archive_tab_ni_det(already_l).act_info5 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uap_id);
1959: l_archive_tab_ni_det(already_l).act_info6 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_uel_id);
1960: l_archive_tab_ni_det(already_l).act_info7 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_r_ytd_id);
1961: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_e_ytd_id);
1962: END IF;
1963:
1964: END IF; --Aggregation End
1965: