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_GB_EOY_ARCHIVE dependencies on HR_DIRBAL

Line 4555: l_smp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_smp_id);

4551: IF l_last_asg_action_id IS NOT NULL THEN
4552: /* IF l_sex = 'F' THEN rerstored as a part of 2987008
4553: was earlier commented out for 2003,
4554: And now commented out again for 2005, BUG 4011263 */
4555: l_smp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_smp_id);
4556: /* END IF; */
4557: l_notional := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_notional_id);
4558: l_ssp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_ssp_id);
4559: --

Line 4557: l_notional := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_notional_id);

4553: was earlier commented out for 2003,
4554: And now commented out again for 2005, BUG 4011263 */
4555: l_smp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_smp_id);
4556: /* END IF; */
4557: l_notional := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_notional_id);
4558: l_ssp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_ssp_id);
4559: --
4560: -- 3 Defined Balance checks, can remove these after April 03.
4561: --

Line 4558: l_ssp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_ssp_id);

4554: And now commented out again for 2005, BUG 4011263 */
4555: l_smp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_smp_id);
4556: /* END IF; */
4557: l_notional := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_notional_id);
4558: l_ssp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_ssp_id);
4559: --
4560: -- 3 Defined Balance checks, can remove these after April 03.
4561: --
4562: if g_sap_id is not null then

Line 4563: l_sap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_sap_id);

4559: --
4560: -- 3 Defined Balance checks, can remove these after April 03.
4561: --
4562: if g_sap_id is not null then
4563: l_sap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_sap_id);
4564: end if;
4565: --
4566: if g_spp_adopt_id is not null then
4567: l_spp_adopt :=

Line 4568: 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_spp_adopt_id);

4564: end if;
4565: --
4566: if g_spp_adopt_id is not null then
4567: l_spp_adopt :=
4568: 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_spp_adopt_id);
4569: end if;
4570: --
4571: if g_spp_birth_id is not null then
4572: l_spp_birth :=

Line 4573: 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_spp_birth_id);

4569: end if;
4570: --
4571: if g_spp_birth_id is not null then
4572: l_spp_birth :=
4573: 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_spp_birth_id);
4574: end if;
4575: --
4576: -- Gross Pay includes Notional Pay balance
4577: --

Line 4578: l_gross := (100 * hr_dirbal.get_balance(l_last_asg_action_id,g_gross_id)) +

4574: end if;
4575: --
4576: -- Gross Pay includes Notional Pay balance
4577: --
4578: l_gross := (100 * hr_dirbal.get_balance(l_last_asg_action_id,g_gross_id)) +
4579: l_notional;
4580: l_super := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_super_id);
4581: l_taxable := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4582: g_taxable_id);

Line 4580: l_super := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_super_id);

4576: -- Gross Pay includes Notional Pay balance
4577: --
4578: l_gross := (100 * hr_dirbal.get_balance(l_last_asg_action_id,g_gross_id)) +
4579: l_notional;
4580: l_super := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_super_id);
4581: l_taxable := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4582: g_taxable_id);
4583: l_student_loan := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4584: g_student_loan_id);

Line 4581: l_taxable := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

4577: --
4578: l_gross := (100 * hr_dirbal.get_balance(l_last_asg_action_id,g_gross_id)) +
4579: l_notional;
4580: l_super := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_super_id);
4581: l_taxable := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4582: g_taxable_id);
4583: l_student_loan := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4584: g_student_loan_id);
4585: --

Line 4583: l_student_loan := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

4579: l_notional;
4580: l_super := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_super_id);
4581: l_taxable := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4582: g_taxable_id);
4583: l_student_loan := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4584: g_student_loan_id);
4585: --
4586: l_ni_arrears := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4587: g_ni_arrears_id);

Line 4586: l_ni_arrears := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

4582: g_taxable_id);
4583: l_student_loan := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4584: g_student_loan_id);
4585: --
4586: l_ni_arrears := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4587: g_ni_arrears_id);
4588: --
4589: -- Start of Bug 6271548
4590: -- fetch PAYE balance for checking whether this assignment reported in

Line 4592: l_paye := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_paye_id);

4588: --
4589: -- Start of Bug 6271548
4590: -- fetch PAYE balance for checking whether this assignment reported in
4591: -- the P35 report or not
4592: l_paye := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_paye_id);
4593:
4594: -- fetch previous_taxable_pay,previous_tax_paid balances -- Bug 6271548
4595: --
4596: IF l_action_type <> 'V' THEN

Line 4814: l_nia_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);

4810: -- reported in the P35 report or not. -- Bug 6271548
4811:
4812: hr_utility.trace('fetching NI x Total/Able balances');
4813: -- NI A
4814: l_nia_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);
4815: l_nia_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4816: g_nia_able_id);
4817:
4818: -- NI B

Line 4815: l_nia_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

4811:
4812: hr_utility.trace('fetching NI x Total/Able balances');
4813: -- NI A
4814: l_nia_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);
4815: l_nia_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4816: g_nia_able_id);
4817:
4818: -- NI B
4819: l_nib_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id, g_nib_tot_id);

Line 4819: l_nib_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id, g_nib_tot_id);

4815: l_nia_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4816: g_nia_able_id);
4817:
4818: -- NI B
4819: l_nib_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id, g_nib_tot_id);
4820: l_nib_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4821: g_nib_able_id);
4822:
4823: -- NI C

Line 4820: l_nib_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

4816: g_nia_able_id);
4817:
4818: -- NI B
4819: l_nib_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id, g_nib_tot_id);
4820: l_nib_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4821: g_nib_able_id);
4822:
4823: -- NI C
4824: l_nic_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);

Line 4824: l_nic_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);

4820: l_nib_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4821: g_nib_able_id);
4822:
4823: -- NI C
4824: l_nic_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);
4825: l_nic_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4826: g_nic_able_id);
4827:
4828: -- NI D

Line 4825: l_nic_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

4821: g_nib_able_id);
4822:
4823: -- NI C
4824: l_nic_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);
4825: l_nic_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4826: g_nic_able_id);
4827:
4828: -- NI D
4829: l_nid_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);

Line 4829: l_nid_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);

4825: l_nic_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4826: g_nic_able_id);
4827:
4828: -- NI D
4829: l_nid_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);
4830: l_nid_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4831: g_nid_able_id);
4832:
4833: -- NI E

Line 4830: l_nid_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

4826: g_nic_able_id);
4827:
4828: -- NI D
4829: l_nid_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);
4830: l_nid_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4831: g_nid_able_id);
4832:
4833: -- NI E
4834: l_nie_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);

Line 4834: l_nie_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);

4830: l_nid_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4831: g_nid_able_id);
4832:
4833: -- NI E
4834: l_nie_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);
4835: l_nie_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4836: g_nie_able_id);
4837:
4838: -- NI J

Line 4835: l_nie_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

4831: g_nid_able_id);
4832:
4833: -- NI E
4834: l_nie_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);
4835: l_nie_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4836: g_nie_able_id);
4837:
4838: -- NI J
4839: l_nij_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);

Line 4839: l_nij_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);

4835: l_nie_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4836: g_nie_able_id);
4837:
4838: -- NI J
4839: l_nij_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);
4840: l_nij_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4841: g_nij_able_id);
4842:
4843: -- NI L

Line 4840: l_nij_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

4836: g_nie_able_id);
4837:
4838: -- NI J
4839: l_nij_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);
4840: l_nij_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4841: g_nij_able_id);
4842:
4843: -- NI L
4844: l_nil_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);

Line 4844: l_nil_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);

4840: l_nij_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4841: g_nij_able_id);
4842:
4843: -- NI L
4844: l_nil_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);
4845: l_nil_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4846: g_nil_able_id);
4847:
4848: -- NI F,G,S

Line 4845: l_nil_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

4841: g_nij_able_id);
4842:
4843: -- NI L
4844: l_nil_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);
4845: l_nil_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4846: g_nil_able_id);
4847:
4848: -- NI F,G,S
4849: hr_utility.trace('fetching NI x Total/Able balances for F,G,S category');

Line 5039: l_paye := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_paye_id);

5035: archive_asg_info(g_postal_code_eid,l_postal_code);
5036: --
5037: hr_utility.trace('End of archiving person and address info');
5038: -- Get more Non-NI balances and codes
5039: l_paye := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_paye_id);
5040: l_widow := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_widow_id);
5041: hr_utility.set_location(l_proc,50);
5042: hr_utility.trace('l_paye='||l_paye||', g_paye_id='||g_paye_id);
5043: IF nvl(l_aggregated_paye_flag,'N') <> 'Y' THEN

Line 5040: l_widow := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_widow_id);

5036: --
5037: hr_utility.trace('End of archiving person and address info');
5038: -- Get more Non-NI balances and codes
5039: l_paye := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_paye_id);
5040: l_widow := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_widow_id);
5041: hr_utility.set_location(l_proc,50);
5042: hr_utility.trace('l_paye='||l_paye||', g_paye_id='||g_paye_id);
5043: IF nvl(l_aggregated_paye_flag,'N') <> 'Y' THEN
5044: -- Not Aggregated PAYE, so archive all values as prior to

Line 5369: /* l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);

5365: -- due to already fetch
5366:
5367: -- Get NI balances
5368: -- NI A
5369: /* l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);
5370: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5371: g_nia_able_id); */
5372: IF nvl(l_nia_tot,0) <> 0 or nvl(l_nia_able,0) <> 0 THEN
5373: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN

Line 5370: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5366:
5367: -- Get NI balances
5368: -- NI A
5369: /* l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);
5370: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5371: g_nia_able_id); */
5372: IF nvl(l_nia_tot,0) <> 0 or nvl(l_nia_able,0) <> 0 THEN
5373: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5374: hr_utility.set_location(l_proc,70);

Line 5376: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_id);

5372: IF nvl(l_nia_tot,0) <> 0 or nvl(l_nia_able,0) <> 0 THEN
5373: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5374: hr_utility.set_location(l_proc,70);
5375:
5376: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_id);
5377: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5378: g_nia_lel_id);
5379: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5380: g_nia_uel_id);

Line 5377: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5373: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5374: hr_utility.set_location(l_proc,70);
5375:
5376: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_id);
5377: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5378: g_nia_lel_id);
5379: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5380: g_nia_uel_id);
5381: --EOY 07/08 Begin

Line 5379: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5375:
5376: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_id);
5377: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5378: g_nia_lel_id);
5379: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5380: g_nia_uel_id);
5381: --EOY 07/08 Begin
5382: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5383: g_nia_auel_id);

Line 5382: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5378: g_nia_lel_id);
5379: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5380: g_nia_uel_id);
5381: --EOY 07/08 Begin
5382: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5383: g_nia_auel_id);
5384: --EOY 07/08 End
5385: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5386: g_nia_et_id);

Line 5385: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5381: --EOY 07/08 Begin
5382: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5383: g_nia_auel_id);
5384: --EOY 07/08 End
5385: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5386: g_nia_et_id);
5387: /* EOY 07/08 Begin
5388: archive_ni_values('A', l_nia_tot, l_nia_able, l_ni_ees, l_ni_able_lel,
5389: l_ni_able_et, l_ni_able_uel); */

Line 5404: /* l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5400: l_ni_able_auel := NULL; --EOY 07/08 Begin
5401: l_ni_able_et := NULL;
5402: -- NI B
5403: /* IF l_sex = 'F' THEN -- Cat B is for Females only Bug 4011263, EOY 2005*/
5404: /* l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5405: g_nib_tot_id);
5406: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5407: g_nib_able_id);*/
5408: IF nvl(l_nib_tot,0) <> 0 or nvl(l_nib_able,0) <> 0 THEN

Line 5406: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5402: -- NI B
5403: /* IF l_sex = 'F' THEN -- Cat B is for Females only Bug 4011263, EOY 2005*/
5404: /* l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5405: g_nib_tot_id);
5406: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5407: g_nib_able_id);*/
5408: IF nvl(l_nib_tot,0) <> 0 or nvl(l_nib_able,0) <> 0 THEN
5409: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5410: hr_utility.set_location(l_proc,80);

Line 5411: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5407: g_nib_able_id);*/
5408: IF nvl(l_nib_tot,0) <> 0 or nvl(l_nib_able,0) <> 0 THEN
5409: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5410: hr_utility.set_location(l_proc,80);
5411: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5412: g_nib_id);
5413: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5414: g_nib_lel_id);
5415: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

Line 5413: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5409: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5410: hr_utility.set_location(l_proc,80);
5411: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5412: g_nib_id);
5413: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5414: g_nib_lel_id);
5415: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5416: g_nib_uel_id);
5417: --EOY 07/08 Begin

Line 5415: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5411: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5412: g_nib_id);
5413: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5414: g_nib_lel_id);
5415: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5416: g_nib_uel_id);
5417: --EOY 07/08 Begin
5418: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5419: g_nib_auel_id);

Line 5418: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5414: g_nib_lel_id);
5415: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5416: g_nib_uel_id);
5417: --EOY 07/08 Begin
5418: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5419: g_nib_auel_id);
5420: --EOY 07/08 End
5421: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5422: g_nib_et_id);

Line 5421: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5417: --EOY 07/08 Begin
5418: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5419: g_nib_auel_id);
5420: --EOY 07/08 End
5421: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5422: g_nib_et_id);
5423: /* EOY 07/08 Begin
5424: archive_ni_values('B', l_nib_tot, l_nib_able, l_ni_ees, l_ni_able_lel,
5425: l_ni_able_et, l_ni_able_uel); */

Line 5441: /l_ni_tot := 100 hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);

5437: l_ni_able_auel := NULL; -- EOY 07/08
5438: l_ni_able_et := NULL;
5439: l_ers_rebate := NULL;
5440: -- NI C
5441: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);
5442: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5443: g_nic_able_id);*/
5444: IF nvl(l_nic_tot,0) <> 0 or nvl(l_nic_able,0) <> 0 THEN
5445: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN

Line 5442: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5438: l_ni_able_et := NULL;
5439: l_ers_rebate := NULL;
5440: -- NI C
5441: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);
5442: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5443: g_nic_able_id);*/
5444: IF nvl(l_nic_tot,0) <> 0 or nvl(l_nic_able,0) <> 0 THEN
5445: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5446: hr_utility.set_location(l_proc,90);

Line 5451: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5447: --archive_ni_values('C', l_ni_tot);
5448: -- Bug Fix 1976152, commented the above stmt, and included the below code
5449: -- to get the balance for NI C Employers Rebate and modified the call to
5450: -- archive_ni_values procedure
5451: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5452: g_nic_lel_id);
5453: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5454: g_nic_uel_id);
5455: --EOY 07/08 Begin

Line 5453: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5449: -- to get the balance for NI C Employers Rebate and modified the call to
5450: -- archive_ni_values procedure
5451: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5452: g_nic_lel_id);
5453: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5454: g_nic_uel_id);
5455: --EOY 07/08 Begin
5456: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5457: g_nic_auel_id);

Line 5456: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5452: g_nic_lel_id);
5453: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5454: g_nic_uel_id);
5455: --EOY 07/08 Begin
5456: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5457: g_nic_auel_id);
5458: --EOY 07/08 End
5459: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5460: g_nic_et_id);

Line 5459: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5455: --EOY 07/08 Begin
5456: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5457: g_nic_auel_id);
5458: --EOY 07/08 End
5459: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5460: g_nic_et_id);
5461: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_ers_rebate_id);
5462: /* EOY 07/08 Begin
5463: archive_ni_values(p_ni_cat => 'C',

Line 5461: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_ers_rebate_id);

5457: g_nic_auel_id);
5458: --EOY 07/08 End
5459: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5460: g_nic_et_id);
5461: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_ers_rebate_id);
5462: /* EOY 07/08 Begin
5463: archive_ni_values(p_ni_cat => 'C',
5464: p_tot_contribs => l_nic_tot,
5465: p_earnings => l_nic_able,

Line 5492: /l_ni_tot := 100 hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);

5488: l_ni_able_et := NULL;
5489: l_ers_rebate := NULL;
5490: l_rebate_emp := NULL;
5491: -- NI D
5492: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);
5493: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5494: g_nid_able_id);*/
5495: IF nvl(l_nid_tot,0) <> 0 or nvl(l_nid_able,0) <> 0 THEN
5496: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN

Line 5493: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5489: l_ers_rebate := NULL;
5490: l_rebate_emp := NULL;
5491: -- NI D
5492: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);
5493: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5494: g_nid_able_id);*/
5495: IF nvl(l_nid_tot,0) <> 0 or nvl(l_nid_able,0) <> 0 THEN
5496: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5497: hr_utility.set_location(l_proc,100);

Line 5498: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_id);

5494: g_nid_able_id);*/
5495: IF nvl(l_nid_tot,0) <> 0 or nvl(l_nid_able,0) <> 0 THEN
5496: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5497: hr_utility.set_location(l_proc,100);
5498: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_id);
5499: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5500: g_nid_lel_id);
5501: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5502: g_nid_uel_id);

Line 5499: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5495: IF nvl(l_nid_tot,0) <> 0 or nvl(l_nid_able,0) <> 0 THEN
5496: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5497: hr_utility.set_location(l_proc,100);
5498: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_id);
5499: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5500: g_nid_lel_id);
5501: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5502: g_nid_uel_id);
5503: --EOY 07/08 Begin

Line 5501: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5497: hr_utility.set_location(l_proc,100);
5498: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_id);
5499: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5500: g_nid_lel_id);
5501: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5502: g_nid_uel_id);
5503: --EOY 07/08 Begin
5504: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5505: g_nid_auel_id);

Line 5504: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5500: g_nid_lel_id);
5501: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5502: g_nid_uel_id);
5503: --EOY 07/08 Begin
5504: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5505: g_nid_auel_id);
5506: --EOY 07/08 End
5507: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5508: g_nid_et_id);

Line 5507: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5503: --EOY 07/08 Begin
5504: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5505: g_nid_auel_id);
5506: --EOY 07/08 End
5507: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5508: g_nid_et_id);
5509: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5510: g_nid_ers_rebate_id);
5511: l_ees_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

Line 5509: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5505: g_nid_auel_id);
5506: --EOY 07/08 End
5507: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5508: g_nid_et_id);
5509: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5510: g_nid_ers_rebate_id);
5511: l_ees_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5512: g_nid_ees_rebate_id);
5513: l_rebate_emp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

Line 5511: l_ees_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5507: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5508: g_nid_et_id);
5509: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5510: g_nid_ers_rebate_id);
5511: l_ees_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5512: g_nid_ees_rebate_id);
5513: l_rebate_emp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5514: g_nid_rebate_emp_id);
5515: /*EOY 07/08 Begin

Line 5513: l_rebate_emp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5509: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5510: g_nid_ers_rebate_id);
5511: l_ees_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5512: g_nid_ees_rebate_id);
5513: l_rebate_emp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5514: g_nid_rebate_emp_id);
5515: /*EOY 07/08 Begin
5516: archive_ni_values('D', l_nid_tot, l_nid_able, l_ni_ees, l_ni_able_lel,
5517: l_ni_able_et, l_ni_able_uel,l_ers_rebate + l_ees_rebate - l_rebate_emp,

Line 5536: /l_ni_tot := 100 hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);

5532: l_ers_rebate := NULL;
5533: l_ees_rebate := NULL;
5534: -- NI E
5535: /* IF l_sex = 'F' THEN -- Cat E is for Females only Bug 4011263, EOY 2005*/
5536: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);
5537: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_able_id);*/
5538: IF nvl(l_nie_tot,0) <> 0 or nvl(l_nie_able,0) <> 0 THEN
5539: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5540: hr_utility.set_location(l_proc,110);

Line 5537: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_able_id);*/

5533: l_ees_rebate := NULL;
5534: -- NI E
5535: /* IF l_sex = 'F' THEN -- Cat E is for Females only Bug 4011263, EOY 2005*/
5536: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);
5537: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_able_id);*/
5538: IF nvl(l_nie_tot,0) <> 0 or nvl(l_nie_able,0) <> 0 THEN
5539: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5540: hr_utility.set_location(l_proc,110);
5541: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_id);

Line 5541: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_id);

5537: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_able_id);*/
5538: IF nvl(l_nie_tot,0) <> 0 or nvl(l_nie_able,0) <> 0 THEN
5539: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5540: hr_utility.set_location(l_proc,110);
5541: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_id);
5542: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_lel_id);
5543: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uel_id);
5544: --EOY 07/08 Begin
5545: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);

Line 5542: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_lel_id);

5538: IF nvl(l_nie_tot,0) <> 0 or nvl(l_nie_able,0) <> 0 THEN
5539: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5540: hr_utility.set_location(l_proc,110);
5541: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_id);
5542: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_lel_id);
5543: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uel_id);
5544: --EOY 07/08 Begin
5545: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);
5546: --EOY 07/08 End

Line 5543: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uel_id);

5539: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5540: hr_utility.set_location(l_proc,110);
5541: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_id);
5542: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_lel_id);
5543: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uel_id);
5544: --EOY 07/08 Begin
5545: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);
5546: --EOY 07/08 End
5547: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_et_id);

Line 5545: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);

5541: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_id);
5542: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_lel_id);
5543: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uel_id);
5544: --EOY 07/08 Begin
5545: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);
5546: --EOY 07/08 End
5547: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_et_id);
5548: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_ers_rebate_id);
5549: /*EOY 07/08 Begin

Line 5547: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_et_id);

5543: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uel_id);
5544: --EOY 07/08 Begin
5545: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);
5546: --EOY 07/08 End
5547: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_et_id);
5548: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_ers_rebate_id);
5549: /*EOY 07/08 Begin
5550: archive_ni_values('E', l_nie_tot, l_nie_able, l_ni_ees, l_ni_able_lel,l_ni_able_et, l_ni_able_uel,l_ers_rebate);*/
5551: archive_ni_values('E', l_nie_tot, l_nie_able, l_ni_ees, l_ni_able_lel,l_ni_able_et, l_ni_able_uel, l_ni_able_auel, l_ers_rebate);

Line 5548: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_ers_rebate_id);

5544: --EOY 07/08 Begin
5545: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);
5546: --EOY 07/08 End
5547: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_et_id);
5548: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_ers_rebate_id);
5549: /*EOY 07/08 Begin
5550: archive_ni_values('E', l_nie_tot, l_nie_able, l_ni_ees, l_ni_able_lel,l_ni_able_et, l_ni_able_uel,l_ers_rebate);*/
5551: archive_ni_values('E', l_nie_tot, l_nie_able, l_ni_ees, l_ni_able_lel,l_ni_able_et, l_ni_able_uel, l_ni_able_auel, l_ers_rebate);
5552: --EOY 07/08 End

Line 5567: /l_ni_tot := 100 hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);

5563: l_ers_rebate := NULL;
5564: l_ees_rebate := NULL;
5565: l_rebate_emp := NULL;
5566: -- NI J
5567: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);
5568: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5569: g_nij_able_id);*/
5570: IF nvl(l_nij_tot,0) <> 0 or nvl(l_nij_able,0) <> 0 THEN
5571: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN

Line 5568: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5564: l_ees_rebate := NULL;
5565: l_rebate_emp := NULL;
5566: -- NI J
5567: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);
5568: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5569: g_nij_able_id);*/
5570: IF nvl(l_nij_tot,0) <> 0 or nvl(l_nij_able,0) <> 0 THEN
5571: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5572: hr_utility.set_location(l_proc,130);

Line 5573: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_id);

5569: g_nij_able_id);*/
5570: IF nvl(l_nij_tot,0) <> 0 or nvl(l_nij_able,0) <> 0 THEN
5571: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5572: hr_utility.set_location(l_proc,130);
5573: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_id);
5574: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5575: g_nij_lel_id);
5576: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5577: g_nij_uel_id);

Line 5574: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5570: IF nvl(l_nij_tot,0) <> 0 or nvl(l_nij_able,0) <> 0 THEN
5571: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5572: hr_utility.set_location(l_proc,130);
5573: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_id);
5574: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5575: g_nij_lel_id);
5576: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5577: g_nij_uel_id);
5578: --EOY 07/08 Begin

Line 5576: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5572: hr_utility.set_location(l_proc,130);
5573: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_id);
5574: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5575: g_nij_lel_id);
5576: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5577: g_nij_uel_id);
5578: --EOY 07/08 Begin
5579: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5580: g_nij_auel_id);

Line 5579: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5575: g_nij_lel_id);
5576: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5577: g_nij_uel_id);
5578: --EOY 07/08 Begin
5579: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5580: g_nij_auel_id);
5581: --EOY 07/08 End
5582: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5583: g_nij_et_id);

Line 5582: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5578: --EOY 07/08 Begin
5579: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5580: g_nij_auel_id);
5581: --EOY 07/08 End
5582: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5583: g_nij_et_id);
5584: /* EOY 07/08 Begin
5585: archive_ni_values('J', l_nij_tot, l_nij_able, l_ni_ees, l_ni_able_lel,
5586: l_ni_able_et, l_ni_able_uel); */

Line 5601: /l_ni_tot := 100 hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);

5597: l_ni_able_auel := NULL; -- EOY 07/08
5598: l_ni_able_et := NULL;
5599:
5600: -- NI L
5601: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);
5602: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5603: g_nil_able_id);*/
5604: IF nvl(l_nil_tot,0) <> 0 or nvl(l_nil_able,0) <> 0 THEN
5605: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN

Line 5602: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5598: l_ni_able_et := NULL;
5599:
5600: -- NI L
5601: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);
5602: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5603: g_nil_able_id);*/
5604: IF nvl(l_nil_tot,0) <> 0 or nvl(l_nil_able,0) <> 0 THEN
5605: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5606: hr_utility.set_location(l_proc,140);

Line 5607: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_id);

5603: g_nil_able_id);*/
5604: IF nvl(l_nil_tot,0) <> 0 or nvl(l_nil_able,0) <> 0 THEN
5605: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5606: hr_utility.set_location(l_proc,140);
5607: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_id);
5608: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5609: g_nil_lel_id);
5610: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5611: g_nil_uel_id);

Line 5608: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5604: IF nvl(l_nil_tot,0) <> 0 or nvl(l_nil_able,0) <> 0 THEN
5605: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5606: hr_utility.set_location(l_proc,140);
5607: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_id);
5608: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5609: g_nil_lel_id);
5610: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5611: g_nil_uel_id);
5612: --EOY 07/08 Begin

Line 5610: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5606: hr_utility.set_location(l_proc,140);
5607: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_id);
5608: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5609: g_nil_lel_id);
5610: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5611: g_nil_uel_id);
5612: --EOY 07/08 Begin
5613: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5614: g_nil_auel_id);

Line 5613: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5609: g_nil_lel_id);
5610: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5611: g_nil_uel_id);
5612: --EOY 07/08 Begin
5613: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5614: g_nil_auel_id);
5615: --EOY 07/08 End
5616: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5617: g_nil_et_id);

Line 5616: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5612: --EOY 07/08 Begin
5613: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5614: g_nil_auel_id);
5615: --EOY 07/08 End
5616: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5617: g_nil_et_id);
5618: /*EOY 07/08 Begin
5619: archive_ni_values('L', l_nil_tot, l_nil_able, l_ni_ees, l_ni_able_lel,
5620: l_ni_able_et, l_ni_able_uel); */