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 4740: l_smp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_smp_id);

4736: IF l_last_asg_action_id IS NOT NULL THEN
4737: /* IF l_sex = 'F' THEN rerstored as a part of 2987008
4738: was earlier commented out for 2003,
4739: And now commented out again for 2005, BUG 4011263 */
4740: l_smp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_smp_id);
4741: /* END IF; */
4742: l_notional := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_notional_id);
4743: l_ssp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_ssp_id);
4744: --

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

4738: was earlier commented out for 2003,
4739: And now commented out again for 2005, BUG 4011263 */
4740: l_smp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_smp_id);
4741: /* END IF; */
4742: l_notional := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_notional_id);
4743: l_ssp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_ssp_id);
4744: --
4745: -- 3 Defined Balance checks, can remove these after April 03.
4746: --

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

4739: And now commented out again for 2005, BUG 4011263 */
4740: l_smp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_smp_id);
4741: /* END IF; */
4742: l_notional := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_notional_id);
4743: l_ssp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_ssp_id);
4744: --
4745: -- 3 Defined Balance checks, can remove these after April 03.
4746: --
4747: if g_sap_id is not null then

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

4744: --
4745: -- 3 Defined Balance checks, can remove these after April 03.
4746: --
4747: if g_sap_id is not null then
4748: l_sap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_sap_id);
4749: end if;
4750: --
4751: if g_spp_adopt_id is not null then
4752: l_spp_adopt :=

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

4749: end if;
4750: --
4751: if g_spp_adopt_id is not null then
4752: l_spp_adopt :=
4753: 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_spp_adopt_id);
4754: end if;
4755: --
4756: if g_spp_birth_id is not null then
4757: l_spp_birth :=

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

4754: end if;
4755: --
4756: if g_spp_birth_id is not null then
4757: l_spp_birth :=
4758: 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_spp_birth_id);
4759: end if;
4760: -- EOY Changes 2011/12
4761:
4762: if g_aspp_adopt_id is not null then

Line 4764: 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_aspp_adopt_id);

4760: -- EOY Changes 2011/12
4761:
4762: if g_aspp_adopt_id is not null then
4763: l_aspp_adopt :=
4764: 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_aspp_adopt_id);
4765: end if;
4766: --
4767: if g_aspp_birth_id is not null then
4768: l_aspp_birth :=

Line 4769: 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_aspp_birth_id);

4765: end if;
4766: --
4767: if g_aspp_birth_id is not null then
4768: l_aspp_birth :=
4769: 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_aspp_birth_id);
4770: end if;
4771: --
4772: -- Gross Pay includes Notional Pay balance
4773: --

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

4770: end if;
4771: --
4772: -- Gross Pay includes Notional Pay balance
4773: --
4774: l_gross := (100 * hr_dirbal.get_balance(l_last_asg_action_id,g_gross_id)) +
4775: l_notional;
4776: l_super := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_super_id);
4777: l_taxable := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4778: g_taxable_id);

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

4772: -- Gross Pay includes Notional Pay balance
4773: --
4774: l_gross := (100 * hr_dirbal.get_balance(l_last_asg_action_id,g_gross_id)) +
4775: l_notional;
4776: l_super := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_super_id);
4777: l_taxable := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4778: g_taxable_id);
4779: l_student_loan := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4780: g_student_loan_id);

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

4773: --
4774: l_gross := (100 * hr_dirbal.get_balance(l_last_asg_action_id,g_gross_id)) +
4775: l_notional;
4776: l_super := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_super_id);
4777: l_taxable := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4778: g_taxable_id);
4779: l_student_loan := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4780: g_student_loan_id);
4781: --

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

4775: l_notional;
4776: l_super := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_super_id);
4777: l_taxable := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4778: g_taxable_id);
4779: l_student_loan := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4780: g_student_loan_id);
4781: --
4782: l_ni_arrears := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4783: g_ni_arrears_id);

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

4778: g_taxable_id);
4779: l_student_loan := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4780: g_student_loan_id);
4781: --
4782: l_ni_arrears := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
4783: g_ni_arrears_id);
4784: --
4785: -- Start of Bug 6271548
4786: -- fetch PAYE balance for checking whether this assignment reported in

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

4784: --
4785: -- Start of Bug 6271548
4786: -- fetch PAYE balance for checking whether this assignment reported in
4787: -- the P35 report or not
4788: l_paye := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_paye_id);
4789:
4790: -- fetch previous_taxable_pay,previous_tax_paid balances -- Bug 6271548
4791: --
4792: IF l_action_type <> 'V' THEN

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

5006: -- reported in the P35 report or not. -- Bug 6271548
5007:
5008: hr_utility.trace('fetching NI x Total/Able balances');
5009: -- NI A
5010: l_nia_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);
5011: l_nia_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5012: g_nia_able_id);
5013:
5014: -- NI B

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

5007:
5008: hr_utility.trace('fetching NI x Total/Able balances');
5009: -- NI A
5010: l_nia_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);
5011: l_nia_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5012: g_nia_able_id);
5013:
5014: -- NI B
5015: l_nib_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id, g_nib_tot_id);

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

5011: l_nia_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5012: g_nia_able_id);
5013:
5014: -- NI B
5015: l_nib_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id, g_nib_tot_id);
5016: l_nib_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5017: g_nib_able_id);
5018:
5019: -- NI C

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

5012: g_nia_able_id);
5013:
5014: -- NI B
5015: l_nib_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id, g_nib_tot_id);
5016: l_nib_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5017: g_nib_able_id);
5018:
5019: -- NI C
5020: l_nic_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);

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

5016: l_nib_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5017: g_nib_able_id);
5018:
5019: -- NI C
5020: l_nic_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);
5021: l_nic_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5022: g_nic_able_id);
5023:
5024: -- NI D

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

5017: g_nib_able_id);
5018:
5019: -- NI C
5020: l_nic_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);
5021: l_nic_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5022: g_nic_able_id);
5023:
5024: -- NI D
5025: l_nid_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);

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

5021: l_nic_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5022: g_nic_able_id);
5023:
5024: -- NI D
5025: l_nid_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);
5026: l_nid_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5027: g_nid_able_id);
5028:
5029: -- NI E

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

5022: g_nic_able_id);
5023:
5024: -- NI D
5025: l_nid_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);
5026: l_nid_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5027: g_nid_able_id);
5028:
5029: -- NI E
5030: l_nie_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);

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

5026: l_nid_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5027: g_nid_able_id);
5028:
5029: -- NI E
5030: l_nie_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);
5031: l_nie_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5032: g_nie_able_id);
5033:
5034: -- NI J

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

5027: g_nid_able_id);
5028:
5029: -- NI E
5030: l_nie_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);
5031: l_nie_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5032: g_nie_able_id);
5033:
5034: -- NI J
5035: l_nij_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);

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

5031: l_nie_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5032: g_nie_able_id);
5033:
5034: -- NI J
5035: l_nij_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);
5036: l_nij_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5037: g_nij_able_id);
5038:
5039: -- NI L

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

5032: g_nie_able_id);
5033:
5034: -- NI J
5035: l_nij_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);
5036: l_nij_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5037: g_nij_able_id);
5038:
5039: -- NI L
5040: l_nil_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);

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

5036: l_nij_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5037: g_nij_able_id);
5038:
5039: -- NI L
5040: l_nil_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);
5041: l_nil_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5042: g_nil_able_id);
5043:
5044: -- NI F,G,S --EOY 2012/2013 begin block

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

5037: g_nij_able_id);
5038:
5039: -- NI L
5040: l_nil_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);
5041: l_nil_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5042: g_nil_able_id);
5043:
5044: -- NI F,G,S --EOY 2012/2013 begin block
5045: /* hr_utility.trace('fetching NI x Total/Able balances for F,G,S category');

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

5246: archive_asg_info(g_postal_code_eid,l_postal_code);
5247: --
5248: hr_utility.trace('End of archiving person and address info');
5249: -- Get more Non-NI balances and codes
5250: l_paye := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_paye_id);
5251: l_widow := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_widow_id);
5252: hr_utility.set_location(l_proc,50);
5253: hr_utility.trace('l_paye='||l_paye||', g_paye_id='||g_paye_id);
5254: IF nvl(l_aggregated_paye_flag,'N') <> 'Y' THEN

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

5247: --
5248: hr_utility.trace('End of archiving person and address info');
5249: -- Get more Non-NI balances and codes
5250: l_paye := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_paye_id);
5251: l_widow := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_widow_id);
5252: hr_utility.set_location(l_proc,50);
5253: hr_utility.trace('l_paye='||l_paye||', g_paye_id='||g_paye_id);
5254: IF nvl(l_aggregated_paye_flag,'N') <> 'Y' THEN
5255: -- Not Aggregated PAYE, so archive all values as prior to

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

5582: -- due to already fetch
5583:
5584: -- Get NI balances
5585: -- NI A
5586: /* l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);
5587: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5588: g_nia_able_id); */
5589: IF nvl(l_nia_tot,0) <> 0 or nvl(l_nia_able,0) <> 0 THEN
5590: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN

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

5583:
5584: -- Get NI balances
5585: -- NI A
5586: /* l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_tot_id);
5587: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5588: g_nia_able_id); */
5589: IF nvl(l_nia_tot,0) <> 0 or nvl(l_nia_able,0) <> 0 THEN
5590: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5591: hr_utility.set_location(l_proc,70);

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

5589: IF nvl(l_nia_tot,0) <> 0 or nvl(l_nia_able,0) <> 0 THEN
5590: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5591: hr_utility.set_location(l_proc,70);
5592:
5593: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_id);
5594: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5595: g_nia_lel_id);
5596: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5597: g_nia_uel_id);

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

5590: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5591: hr_utility.set_location(l_proc,70);
5592:
5593: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_id);
5594: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5595: g_nia_lel_id);
5596: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5597: g_nia_uel_id);
5598: -- 8357870 Begin

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

5592:
5593: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nia_id);
5594: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5595: g_nia_lel_id);
5596: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5597: g_nia_uel_id);
5598: -- 8357870 Begin
5599: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5600: g_nia_uap_id);

Line 5599: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5595: g_nia_lel_id);
5596: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5597: g_nia_uel_id);
5598: -- 8357870 Begin
5599: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5600: g_nia_uap_id);
5601: -- 8357870 End
5602: --EOY 07/08 Begin
5603: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

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

5599: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5600: g_nia_uap_id);
5601: -- 8357870 End
5602: --EOY 07/08 Begin
5603: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5604: g_nia_auel_id);
5605: --EOY 07/08 End
5606: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5607: g_nia_et_id);

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

5602: --EOY 07/08 Begin
5603: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5604: g_nia_auel_id);
5605: --EOY 07/08 End
5606: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5607: g_nia_et_id);
5608: /* EOY 07/08 Begin
5609: archive_ni_values('A', l_nia_tot, l_nia_able, l_ni_ees, l_ni_able_lel,
5610: l_ni_able_et, l_ni_able_uel); */

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

5622: l_ni_able_auel := NULL; --EOY 07/08 Begin
5623: l_ni_able_et := NULL;
5624: -- NI B
5625: /* IF l_sex = 'F' THEN -- Cat B is for Females only Bug 4011263, EOY 2005*/
5626: /* l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5627: g_nib_tot_id);
5628: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5629: g_nib_able_id);*/
5630: IF nvl(l_nib_tot,0) <> 0 or nvl(l_nib_able,0) <> 0 THEN

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

5624: -- NI B
5625: /* IF l_sex = 'F' THEN -- Cat B is for Females only Bug 4011263, EOY 2005*/
5626: /* l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5627: g_nib_tot_id);
5628: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5629: g_nib_able_id);*/
5630: IF nvl(l_nib_tot,0) <> 0 or nvl(l_nib_able,0) <> 0 THEN
5631: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5632: hr_utility.set_location(l_proc,80);

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

5629: g_nib_able_id);*/
5630: IF nvl(l_nib_tot,0) <> 0 or nvl(l_nib_able,0) <> 0 THEN
5631: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5632: hr_utility.set_location(l_proc,80);
5633: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5634: g_nib_id);
5635: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5636: g_nib_lel_id);
5637: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

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

5631: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5632: hr_utility.set_location(l_proc,80);
5633: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5634: g_nib_id);
5635: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5636: g_nib_lel_id);
5637: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5638: g_nib_uel_id);
5639: -- 8357870 begin

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

5633: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5634: g_nib_id);
5635: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5636: g_nib_lel_id);
5637: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5638: g_nib_uel_id);
5639: -- 8357870 begin
5640: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5641: g_nib_uap_id);

Line 5640: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5636: g_nib_lel_id);
5637: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5638: g_nib_uel_id);
5639: -- 8357870 begin
5640: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5641: g_nib_uap_id);
5642: -- 8357870 end
5643: --EOY 07/08 Begin
5644: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

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

5640: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5641: g_nib_uap_id);
5642: -- 8357870 end
5643: --EOY 07/08 Begin
5644: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5645: g_nib_auel_id);
5646: --EOY 07/08 End
5647: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5648: g_nib_et_id);

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

5643: --EOY 07/08 Begin
5644: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5645: g_nib_auel_id);
5646: --EOY 07/08 End
5647: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5648: g_nib_et_id);
5649: /* EOY 07/08 Begin
5650: archive_ni_values('B', l_nib_tot, l_nib_able, l_ni_ees, l_ni_able_lel,
5651: l_ni_able_et, l_ni_able_uel); */

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

5664: l_ni_able_auel := NULL; -- EOY 07/08
5665: l_ni_able_et := NULL;
5666: l_ers_rebate := NULL;
5667: -- NI C
5668: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);
5669: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5670: g_nic_able_id);*/
5671: IF nvl(l_nic_tot,0) <> 0 or nvl(l_nic_able,0) <> 0 THEN
5672: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN

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

5665: l_ni_able_et := NULL;
5666: l_ers_rebate := NULL;
5667: -- NI C
5668: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_tot_id);
5669: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5670: g_nic_able_id);*/
5671: IF nvl(l_nic_tot,0) <> 0 or nvl(l_nic_able,0) <> 0 THEN
5672: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5673: hr_utility.set_location(l_proc,90);

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

5674: --archive_ni_values('C', l_ni_tot);
5675: -- Bug Fix 1976152, commented the above stmt, and included the below code
5676: -- to get the balance for NI C Employers Rebate and modified the call to
5677: -- archive_ni_values procedure
5678: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5679: g_nic_lel_id);
5680: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5681: g_nic_uel_id);
5682: -- 8357870 begin

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

5676: -- to get the balance for NI C Employers Rebate and modified the call to
5677: -- archive_ni_values procedure
5678: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5679: g_nic_lel_id);
5680: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5681: g_nic_uel_id);
5682: -- 8357870 begin
5683: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5684: g_nic_uap_id);

Line 5683: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5679: g_nic_lel_id);
5680: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5681: g_nic_uel_id);
5682: -- 8357870 begin
5683: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5684: g_nic_uap_id);
5685: -- 8357870 end
5686: --EOY 07/08 Begin
5687: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

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

5683: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5684: g_nic_uap_id);
5685: -- 8357870 end
5686: --EOY 07/08 Begin
5687: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5688: g_nic_auel_id);
5689: --EOY 07/08 End
5690: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5691: g_nic_et_id);

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

5686: --EOY 07/08 Begin
5687: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5688: g_nic_auel_id);
5689: --EOY 07/08 End
5690: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5691: g_nic_et_id);
5692: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_ers_rebate_id);
5693: /* EOY 07/08 Begin
5694: archive_ni_values(p_ni_cat => 'C',

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

5688: g_nic_auel_id);
5689: --EOY 07/08 End
5690: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5691: g_nic_et_id);
5692: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nic_ers_rebate_id);
5693: /* EOY 07/08 Begin
5694: archive_ni_values(p_ni_cat => 'C',
5695: p_tot_contribs => l_nic_tot,
5696: p_earnings => l_nic_able,

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

5721: l_ni_able_et := NULL;
5722: l_ers_rebate := NULL;
5723: l_rebate_emp := NULL;
5724: -- NI D
5725: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);
5726: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5727: g_nid_able_id);*/
5728: IF nvl(l_nid_tot,0) <> 0 or nvl(l_nid_able,0) <> 0 THEN
5729: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN

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

5722: l_ers_rebate := NULL;
5723: l_rebate_emp := NULL;
5724: -- NI D
5725: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_tot_id);
5726: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5727: g_nid_able_id);*/
5728: IF nvl(l_nid_tot,0) <> 0 or nvl(l_nid_able,0) <> 0 THEN
5729: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5730: hr_utility.set_location(l_proc,100);

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

5727: g_nid_able_id);*/
5728: IF nvl(l_nid_tot,0) <> 0 or nvl(l_nid_able,0) <> 0 THEN
5729: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5730: hr_utility.set_location(l_proc,100);
5731: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_id);
5732: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5733: g_nid_lel_id);
5734: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5735: g_nid_uel_id);

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

5728: IF nvl(l_nid_tot,0) <> 0 or nvl(l_nid_able,0) <> 0 THEN
5729: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5730: hr_utility.set_location(l_proc,100);
5731: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_id);
5732: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5733: g_nid_lel_id);
5734: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5735: g_nid_uel_id);
5736: -- 8357870 begin

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

5730: hr_utility.set_location(l_proc,100);
5731: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nid_id);
5732: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5733: g_nid_lel_id);
5734: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5735: g_nid_uel_id);
5736: -- 8357870 begin
5737: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5738: g_nid_uap_id);

Line 5737: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5733: g_nid_lel_id);
5734: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5735: g_nid_uel_id);
5736: -- 8357870 begin
5737: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5738: g_nid_uap_id);
5739: -- 8357870 end
5740: --EOY 07/08 Begin
5741: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

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

5737: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5738: g_nid_uap_id);
5739: -- 8357870 end
5740: --EOY 07/08 Begin
5741: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5742: g_nid_auel_id);
5743: --EOY 07/08 End
5744: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5745: g_nid_et_id);

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

5740: --EOY 07/08 Begin
5741: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5742: g_nid_auel_id);
5743: --EOY 07/08 End
5744: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5745: g_nid_et_id);
5746: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5747: g_nid_ers_rebate_id);
5748: l_ees_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

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

5742: g_nid_auel_id);
5743: --EOY 07/08 End
5744: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5745: g_nid_et_id);
5746: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5747: g_nid_ers_rebate_id);
5748: l_ees_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5749: g_nid_ees_rebate_id);
5750: l_rebate_emp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

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

5744: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5745: g_nid_et_id);
5746: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5747: g_nid_ers_rebate_id);
5748: l_ees_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5749: g_nid_ees_rebate_id);
5750: l_rebate_emp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5751: g_nid_rebate_emp_id);
5752: /*EOY 07/08 Begin

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

5746: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5747: g_nid_ers_rebate_id);
5748: l_ees_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5749: g_nid_ees_rebate_id);
5750: l_rebate_emp := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5751: g_nid_rebate_emp_id);
5752: /*EOY 07/08 Begin
5753: archive_ni_values('D', l_nid_tot, l_nid_able, l_ni_ees, l_ni_able_lel,
5754: l_ni_able_et, l_ni_able_uel,l_ers_rebate + l_ees_rebate - l_rebate_emp,

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

5770: l_ers_rebate := NULL;
5771: l_ees_rebate := NULL;
5772: -- NI E
5773: /* IF l_sex = 'F' THEN -- Cat E is for Females only Bug 4011263, EOY 2005*/
5774: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);
5775: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_able_id);*/
5776: IF nvl(l_nie_tot,0) <> 0 or nvl(l_nie_able,0) <> 0 THEN
5777: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5778: hr_utility.set_location(l_proc,110);

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

5771: l_ees_rebate := NULL;
5772: -- NI E
5773: /* IF l_sex = 'F' THEN -- Cat E is for Females only Bug 4011263, EOY 2005*/
5774: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_tot_id);
5775: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_able_id);*/
5776: IF nvl(l_nie_tot,0) <> 0 or nvl(l_nie_able,0) <> 0 THEN
5777: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5778: hr_utility.set_location(l_proc,110);
5779: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_id);

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

5775: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_able_id);*/
5776: IF nvl(l_nie_tot,0) <> 0 or nvl(l_nie_able,0) <> 0 THEN
5777: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5778: hr_utility.set_location(l_proc,110);
5779: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_id);
5780: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_lel_id);
5781: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uel_id);
5782: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uap_id); -- 8357870
5783: --EOY 07/08 Begin

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

5776: IF nvl(l_nie_tot,0) <> 0 or nvl(l_nie_able,0) <> 0 THEN
5777: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5778: hr_utility.set_location(l_proc,110);
5779: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_id);
5780: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_lel_id);
5781: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uel_id);
5782: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uap_id); -- 8357870
5783: --EOY 07/08 Begin
5784: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);

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

5777: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5778: hr_utility.set_location(l_proc,110);
5779: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_id);
5780: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_lel_id);
5781: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uel_id);
5782: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uap_id); -- 8357870
5783: --EOY 07/08 Begin
5784: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);
5785: --EOY 07/08 End

Line 5782: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uap_id); -- 8357870

5778: hr_utility.set_location(l_proc,110);
5779: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_id);
5780: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_lel_id);
5781: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uel_id);
5782: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uap_id); -- 8357870
5783: --EOY 07/08 Begin
5784: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);
5785: --EOY 07/08 End
5786: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_et_id);

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

5780: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_lel_id);
5781: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uel_id);
5782: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uap_id); -- 8357870
5783: --EOY 07/08 Begin
5784: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);
5785: --EOY 07/08 End
5786: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_et_id);
5787: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_ers_rebate_id);
5788: /*EOY 07/08 Begin

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

5782: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_uap_id); -- 8357870
5783: --EOY 07/08 Begin
5784: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);
5785: --EOY 07/08 End
5786: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_et_id);
5787: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_ers_rebate_id);
5788: /*EOY 07/08 Begin
5789: 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);*/
5790: 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_uap, l_ni_able_auel, l_ers_rebate); -- 8357870

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

5783: --EOY 07/08 Begin
5784: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_auel_id);
5785: --EOY 07/08 End
5786: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_et_id);
5787: l_ers_rebate := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nie_ers_rebate_id);
5788: /*EOY 07/08 Begin
5789: 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);*/
5790: 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_uap, l_ni_able_auel, l_ers_rebate); -- 8357870
5791: --EOY 07/08 End

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

5803: l_ers_rebate := NULL;
5804: l_ees_rebate := NULL;
5805: l_rebate_emp := NULL;
5806: -- NI J
5807: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);
5808: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5809: g_nij_able_id);*/
5810: IF nvl(l_nij_tot,0) <> 0 or nvl(l_nij_able,0) <> 0 THEN
5811: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN

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

5804: l_ees_rebate := NULL;
5805: l_rebate_emp := NULL;
5806: -- NI J
5807: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_tot_id);
5808: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5809: g_nij_able_id);*/
5810: IF nvl(l_nij_tot,0) <> 0 or nvl(l_nij_able,0) <> 0 THEN
5811: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5812: hr_utility.set_location(l_proc,130);

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

5809: g_nij_able_id);*/
5810: IF nvl(l_nij_tot,0) <> 0 or nvl(l_nij_able,0) <> 0 THEN
5811: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5812: hr_utility.set_location(l_proc,130);
5813: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_id);
5814: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5815: g_nij_lel_id);
5816: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5817: g_nij_uel_id);

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

5810: IF nvl(l_nij_tot,0) <> 0 or nvl(l_nij_able,0) <> 0 THEN
5811: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5812: hr_utility.set_location(l_proc,130);
5813: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_id);
5814: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5815: g_nij_lel_id);
5816: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5817: g_nij_uel_id);
5818: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

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

5812: hr_utility.set_location(l_proc,130);
5813: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nij_id);
5814: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5815: g_nij_lel_id);
5816: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5817: g_nij_uel_id);
5818: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5819: g_nij_uap_id); -- 8357870
5820: --EOY 07/08 Begin

Line 5818: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5814: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5815: g_nij_lel_id);
5816: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5817: g_nij_uel_id);
5818: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5819: g_nij_uap_id); -- 8357870
5820: --EOY 07/08 Begin
5821: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5822: g_nij_auel_id);

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

5817: g_nij_uel_id);
5818: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5819: g_nij_uap_id); -- 8357870
5820: --EOY 07/08 Begin
5821: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5822: g_nij_auel_id);
5823: --EOY 07/08 End
5824: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5825: g_nij_et_id);

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

5820: --EOY 07/08 Begin
5821: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5822: g_nij_auel_id);
5823: --EOY 07/08 End
5824: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5825: g_nij_et_id);
5826: /* EOY 07/08 Begin
5827: archive_ni_values('J', l_nij_tot, l_nij_able, l_ni_ees, l_ni_able_lel,
5828: l_ni_able_et, l_ni_able_uel); */

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

5840: l_ni_able_auel := NULL; -- EOY 07/08
5841: l_ni_able_et := NULL;
5842:
5843: -- NI L
5844: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);
5845: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5846: g_nil_able_id);*/
5847: IF nvl(l_nil_tot,0) <> 0 or nvl(l_nil_able,0) <> 0 THEN
5848: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN

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

5841: l_ni_able_et := NULL;
5842:
5843: -- NI L
5844: /*l_ni_tot := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_tot_id);
5845: l_ni_able := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5846: g_nil_able_id);*/
5847: IF nvl(l_nil_tot,0) <> 0 or nvl(l_nil_able,0) <> 0 THEN
5848: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5849: hr_utility.set_location(l_proc,140);

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

5846: g_nil_able_id);*/
5847: IF nvl(l_nil_tot,0) <> 0 or nvl(l_nil_able,0) <> 0 THEN
5848: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5849: hr_utility.set_location(l_proc,140);
5850: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_id);
5851: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5852: g_nil_lel_id);
5853: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5854: g_nil_uel_id);

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

5847: IF nvl(l_nil_tot,0) <> 0 or nvl(l_nil_able,0) <> 0 THEN
5848: -- IF nvl(l_ni_tot,0) <> 0 or nvl(l_ni_able,0) <> 0 THEN
5849: hr_utility.set_location(l_proc,140);
5850: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_id);
5851: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5852: g_nil_lel_id);
5853: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5854: g_nil_uel_id);
5855: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

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

5849: hr_utility.set_location(l_proc,140);
5850: l_ni_ees := 100 * hr_dirbal.get_balance(l_last_asg_action_id,g_nil_id);
5851: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5852: g_nil_lel_id);
5853: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5854: g_nil_uel_id);
5855: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5856: g_nil_uap_id); -- 8357870
5857: --EOY 07/08 Begin

Line 5855: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,

5851: l_ni_able_lel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5852: g_nil_lel_id);
5853: l_ni_able_uel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5854: g_nil_uel_id);
5855: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5856: g_nil_uap_id); -- 8357870
5857: --EOY 07/08 Begin
5858: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5859: g_nil_auel_id);

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

5854: g_nil_uel_id);
5855: l_ni_able_uap := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5856: g_nil_uap_id); -- 8357870
5857: --EOY 07/08 Begin
5858: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5859: g_nil_auel_id);
5860: --EOY 07/08 End
5861: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5862: g_nil_et_id);

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

5857: --EOY 07/08 Begin
5858: l_ni_able_auel := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5859: g_nil_auel_id);
5860: --EOY 07/08 End
5861: l_ni_able_et := 100 * hr_dirbal.get_balance(l_last_asg_action_id,
5862: g_nil_et_id);
5863: /*EOY 07/08 Begin
5864: archive_ni_values('L', l_nil_tot, l_nil_able, l_ni_ees, l_ni_able_lel,
5865: l_ni_able_et, l_ni_able_uel); */