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.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_BALANCE_PKG

Line 804: DEBUG('Before calling function pay_balance_pkg.get_value');

800: IF g_debug
801: THEN
802: l_proc_step := 20;
803: DEBUG(l_proc_name, l_proc_step);
804: DEBUG('Before calling function pay_balance_pkg.get_value');
805: DEBUG( 'l_ptpenddt: ' || TO_CHAR(l_ptpenddt(ptpi), 'DD/MON/YYYY'));
806: END IF;
807:
808: BEGIN

Line 810: pay_balance_pkg.get_value(

806: END IF;
807:
808: BEGIN
809: l_balance_value :=
810: pay_balance_pkg.get_value(
811: p_defined_balance_id => p_defined_balance_id
812: ,p_assignment_id => p_assignment_id
813: ,p_virtual_date => l_ptpenddt(ptpi)
814: );

Line 846: DEBUG('Before calling function pay_balance_pkg.get_value');

842: IF g_debug
843: THEN
844: l_proc_step := 20;
845: DEBUG(l_proc_name, l_proc_step);
846: DEBUG('Before calling function pay_balance_pkg.get_value');
847: DEBUG(
848: 'l_effective_date: '
849: || TO_CHAR(l_effective_date, 'DD/MON/YYYY')
850: );

Line 855: pay_balance_pkg.get_value(

851: END IF;
852:
853: BEGIN
854: l_balance_value :=
855: pay_balance_pkg.get_value(
856: p_defined_balance_id => p_defined_balance_id
857: ,p_assignment_id => p_assignment_id
858: ,p_virtual_date => l_effective_date
859: );

Line 3741: pay_balance_pkg.get_value(

3737: ,p_effective_end_date => l_effective_end_date
3738: );
3739: ELSE
3740: l_ni_cont_out_earn :=
3741: pay_balance_pkg.get_value(
3742: p_defined_balance_id => i
3743: ,p_assignment_id => p_assignment_id
3744: ,p_virtual_date => l_effective_end_date);
3745:

Line 3748: -- pay_balance_pkg.get_value(

3744: ,p_virtual_date => l_effective_end_date);
3745:
3746: END IF; -- IF NOT p_ptd_balance
3747:
3748: -- pay_balance_pkg.get_value(
3749: -- p_defined_balance_id => i
3750: -- ,p_assignment_id => p_assignment_id
3751: -- ,p_virtual_date => l_effective_end_date);
3752: -- EXCEPTION

Line 3960: pay_balance_pkg.get_value(

3956: IF NOT p_ptd_balance
3957: THEN
3958: l_wps_contribution :=
3959: -- For 115.29
3960: pay_balance_pkg.get_value(
3961: p_defined_balance_id => l_defined_balance_id(i)
3962: ,p_assignment_id => p_assignment_id
3963: ,p_virtual_date => l_effective_end_date);
3964: ELSE

Line 3966: pay_balance_pkg.get_value(

3962: ,p_assignment_id => p_assignment_id
3963: ,p_virtual_date => l_effective_end_date);
3964: ELSE
3965: l_wps_contribution :=
3966: pay_balance_pkg.get_value(
3967: p_defined_balance_id => l_defined_balance_id(i)
3968: ,p_assignment_id => p_assignment_id
3969: ,p_virtual_date => l_effective_end_date);
3970:

Line 3973: -- pay_balance_pkg.get_value(

3969: ,p_virtual_date => l_effective_end_date);
3970:
3971: END IF; --End if Not p_ptd_balance
3972:
3973: -- pay_balance_pkg.get_value(
3974: -- p_defined_balance_id => l_defined_balance_id(i)
3975: -- ,p_assignment_id => p_assignment_id
3976: -- ,p_virtual_date => l_effective_end_date);
3977: -- EXCEPTION

Line 4179: pay_balance_pkg.get_value(

4175: ,p_effective_end_date => l_effective_end_date
4176: );
4177: ELSE
4178: l_add_yrs_contributions :=
4179: pay_balance_pkg.get_value(
4180: p_defined_balance_id => l_defined_balance_id(i)
4181: ,p_assignment_id => p_assignment_id
4182: ,p_virtual_date => l_effective_end_date);
4183:

Line 4356: pay_balance_pkg.get_value(

4352: IF NOT p_ptd_balance
4353: THEN
4354: l_mp_contributions :=
4355: -- For 115.29
4356: pay_balance_pkg.get_value(
4357: p_defined_balance_id => l_defined_balance_id
4358: ,p_assignment_id => p_assignment_id
4359: ,p_virtual_date => l_effective_end_date);
4360: /* get_total_ptd_bal_value(

Line 4369: pay_balance_pkg.get_value(

4365: ); */
4366:
4367: ELSE
4368: l_mp_contributions :=
4369: pay_balance_pkg.get_value(
4370: p_defined_balance_id => l_defined_balance_id
4371: ,p_assignment_id => p_assignment_id
4372: ,p_virtual_date => l_effective_end_date);
4373:

Line 4375: -- pay_balance_pkg.get_value(

4371: ,p_assignment_id => p_assignment_id
4372: ,p_virtual_date => l_effective_end_date);
4373:
4374: END IF; --End if Not p_ptd_balance
4375: -- pay_balance_pkg.get_value(
4376: -- p_defined_balance_id => l_defined_balance_id
4377: -- ,p_assignment_id => p_assignment_id
4378: -- ,p_virtual_date => l_effective_end_date);
4379: l_total_mp_contributions :=

Line 4548: pay_balance_pkg.get_value(

4544: IF NOT p_ptd_balance
4545: THEN
4546: l_contributions :=
4547: -- For 115.29
4548: pay_balance_pkg.get_value(
4549: p_defined_balance_id => l_defined_balance_id
4550: ,p_assignment_id => p_assignment_id
4551: ,p_virtual_date => l_effective_end_date);
4552:

Line 4561: pay_balance_pkg.get_value(

4557: ,p_effective_end_date => l_effective_end_date
4558: ); */
4559: ELSE
4560: l_contributions :=
4561: pay_balance_pkg.get_value(
4562: p_defined_balance_id => l_defined_balance_id
4563: ,p_assignment_id => p_assignment_id
4564: ,p_virtual_date => l_effective_end_date);
4565:

Line 4568: -- pay_balance_pkg.get_value(

4564: ,p_virtual_date => l_effective_end_date);
4565:
4566: END IF; --End if Not p_ptd_balance
4567:
4568: -- pay_balance_pkg.get_value(
4569: -- p_defined_balance_id => l_defined_balance_id
4570: -- ,p_assignment_id => p_assignment_id
4571: -- ,p_virtual_date => l_effective_end_date);
4572: l_total_contributions :=

Line 4727: pay_balance_pkg.get_value(

4723: IF NOT p_ptd_balance -- For bug 5941475
4724: THEN
4725: l_contributions :=
4726: -- For 115.29
4727: pay_balance_pkg.get_value(
4728: p_defined_balance_id => l_defined_balance_id
4729: ,p_assignment_id => p_assignment_id
4730: ,p_virtual_date => l_effective_end_date);
4731:

Line 4740: pay_balance_pkg.get_value(

4736: ,p_effective_end_date => l_effective_end_date
4737: ); */
4738: ELSE
4739: l_contributions :=
4740: pay_balance_pkg.get_value(
4741: p_defined_balance_id => l_defined_balance_id
4742: ,p_assignment_id => p_assignment_id
4743: ,p_virtual_date => l_effective_end_date);
4744:

Line 4891: pay_balance_pkg.get_value(

4887: ,p_effective_end_date => l_effective_end_date
4888: );
4889: ELSE
4890: l_ni_e_earnings :=
4891: pay_balance_pkg.get_value(
4892: p_defined_balance_id => l_defined_balance_id
4893: ,p_assignment_id => p_assignment_id
4894: ,p_virtual_date => l_effective_end_date);
4895:

Line 4897: -- pay_balance_pkg.get_value(

4893: ,p_assignment_id => p_assignment_id
4894: ,p_virtual_date => l_effective_end_date);
4895:
4896: END IF; --End if Not p_ptd_balance
4897: -- pay_balance_pkg.get_value(
4898: -- p_defined_balance_id => l_defined_balance_id
4899: -- ,p_assignment_id => p_assignment_id
4900: -- ,p_virtual_date => l_effective_end_date);
4901: -- EXCEPTION

Line 5178: pay_balance_pkg.get_value(

5174: THEN
5175: -- BEGIN
5176: l_earnings :=
5177: -- For 115.29
5178: pay_balance_pkg.get_value(
5179: p_defined_balance_id => l_pen_defined_balance_id
5180: ,p_assignment_id => p_assignment_id
5181: ,p_virtual_date => l_effective_end_date);
5182:

Line 5194: pay_balance_pkg.get_value(

5190: -- For Bug 5941475
5191: IF l_check_current_balance = 'Y'
5192: THEN
5193: l_current_earnings :=
5194: pay_balance_pkg.get_value(
5195: p_defined_balance_id => l_defined_balance_id
5196: ,p_assignment_id => p_assignment_id
5197: ,p_virtual_date => l_effective_end_date);
5198:

Line 5206: -- pay_balance_pkg.get_value(

5202: END IF;
5203:
5204: END IF; --End if l_check_current_balance = 'Y'
5205:
5206: -- pay_balance_pkg.get_value(
5207: -- p_defined_balance_id => l_defined_balance_id
5208: -- ,p_assignment_id => p_assignment_id
5209: -- ,p_virtual_date => l_effective_end_date);
5210: -- EXCEPTION

Line 5339: pay_balance_pkg.get_value(

5335: THEN
5336: -- BEGIN
5337: l_earnings :=
5338: -- For 115.29
5339: pay_balance_pkg.get_value(
5340: p_defined_balance_id => l_pen_defined_balance_id
5341: ,p_assignment_id => p_assignment_id
5342: ,p_virtual_date => l_effective_end_date);
5343: /* get_total_ptd_bal_value(

Line 5354: pay_balance_pkg.get_value(

5350: -- For Bug 5941475
5351: IF l_check_current_balance = 'Y'
5352: THEN
5353: l_current_earnings :=
5354: pay_balance_pkg.get_value(
5355: p_defined_balance_id => l_defined_balance_id
5356: ,p_assignment_id => p_assignment_id
5357: ,p_virtual_date => l_effective_end_date);
5358:

Line 5366: -- pay_balance_pkg.get_value(

5362: END IF;
5363:
5364: END IF; --End if l_check_current_balance = 'Y'
5365:
5366: -- pay_balance_pkg.get_value(
5367: -- p_defined_balance_id => l_defined_balance_id
5368: -- ,p_assignment_id => p_assignment_id
5369: -- ,p_virtual_date => l_effective_end_date);
5370: -- EXCEPTION

Line 5422: -- pay_balance_pkg.get_value(

5418: -- ,p_defined_balance_id => l_defined_balance_id
5419: -- ,p_effective_start_date => g_effective_start_date
5420: -- ,p_effective_end_date => l_effective_end_date
5421: -- );
5422: -- pay_balance_pkg.get_value(
5423: -- p_defined_balance_id => l_defined_balance_id
5424: -- ,p_assignment_id => p_assignment_id
5425: -- ,p_virtual_date => l_effective_end_date);
5426: -- EXCEPTION

Line 5510: -- pay_balance_pkg.get_value(

5506: -- ,p_defined_balance_id => l_defined_balance_id
5507: -- ,p_effective_start_date => g_effective_start_date
5508: -- ,p_effective_end_date => l_effective_end_date
5509: -- );
5510: -- pay_balance_pkg.get_value(
5511: -- p_defined_balance_id => l_defined_balance_id
5512: -- ,p_assignment_id => p_assignment_id
5513: -- ,p_virtual_date => l_effective_end_date);
5514: -- EXCEPTION

Line 5580: -- pay_balance_pkg.get_value(

5576: -- ,p_defined_balance_id => l_defined_balance_id
5577: -- ,p_effective_start_date => g_effective_start_date
5578: -- ,p_effective_end_date => l_effective_end_date
5579: -- );
5580: -- pay_balance_pkg.get_value(
5581: -- p_defined_balance_id => l_defined_balance_id
5582: -- ,p_assignment_id => p_assignment_id
5583: -- ,p_virtual_date => l_effective_end_date);
5584: -- EXCEPTION

Line 5651: -- pay_balance_pkg.get_value(

5647: -- ,p_defined_balance_id => l_defined_balance_id
5648: -- ,p_effective_start_date => g_effective_start_date
5649: -- ,p_effective_end_date => l_effective_end_date
5650: -- );
5651: -- pay_balance_pkg.get_value(
5652: -- p_defined_balance_id => l_defined_balance_id
5653: -- ,p_assignment_id => p_assignment_id
5654: -- ,p_virtual_date => l_effective_end_date);
5655: -- EXCEPTION

Line 5703: pay_balance_pkg.get_value(

5699: THEN
5700: -- BEGIN
5701: l_earnings :=
5702: -- For 115.29
5703: pay_balance_pkg.get_value(
5704: p_defined_balance_id => l_pen_defined_balance_id
5705: ,p_assignment_id => p_assignment_id
5706: ,p_virtual_date => l_effective_end_date);
5707:

Line 5719: pay_balance_pkg.get_value(

5715: -- For Bug 5941475
5716: IF l_check_current_balance = 'Y'
5717: THEN
5718: l_current_earnings :=
5719: pay_balance_pkg.get_value(
5720: p_defined_balance_id => l_defined_balance_id
5721: ,p_assignment_id => p_assignment_id
5722: ,p_virtual_date => l_effective_end_date);
5723:

Line 5767: pay_balance_pkg.get_value(

5763: THEN
5764: -- BEGIN
5765: l_earnings :=
5766: -- For 115.29
5767: pay_balance_pkg.get_value(
5768: p_defined_balance_id => l_pen_defined_balance_id
5769: ,p_assignment_id => p_assignment_id
5770: ,p_virtual_date => l_effective_end_date);
5771:

Line 5783: pay_balance_pkg.get_value(

5779: -- For Bug 5941475
5780: IF l_check_current_balance = 'Y'
5781: THEN
5782: l_current_earnings :=
5783: pay_balance_pkg.get_value(
5784: p_defined_balance_id => l_defined_balance_id
5785: ,p_assignment_id => p_assignment_id
5786: ,p_virtual_date => l_effective_end_date);
5787: