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 880: DEBUG('Before calling function pay_balance_pkg.get_value');

876: IF g_debug
877: THEN
878: l_proc_step := 20;
879: DEBUG(l_proc_name, l_proc_step);
880: DEBUG('Before calling function pay_balance_pkg.get_value');
881: DEBUG( 'l_latest_assact_id: ' || l_latest_assact_id);
882: END IF;
883:
884: BEGIN

Line 886: pay_balance_pkg.get_value(

882: END IF;
883:
884: BEGIN
885: l_balance_value :=
886: pay_balance_pkg.get_value(
887: p_defined_balance_id => p_defined_balance_id
888: ,p_assignment_action_id => l_latest_assact_id
889: );
890: EXCEPTION

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

916: IF g_debug
917: THEN
918: l_proc_step := 20;
919: DEBUG(l_proc_name, l_proc_step);
920: DEBUG('Before calling function pay_balance_pkg.get_value');
921: DEBUG( 'l_ptpenddt: ' || TO_CHAR(l_ptpenddt(ptpi), 'DD/MON/YYYY'));
922: END IF;
923:
924: BEGIN

Line 926: pay_balance_pkg.get_value(

922: END IF;
923:
924: BEGIN
925: l_balance_value :=
926: pay_balance_pkg.get_value(
927: p_defined_balance_id => p_defined_balance_id
928: ,p_assignment_id => p_assignment_id
929: ,p_virtual_date => l_ptpenddt(ptpi)
930: );

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

958: IF g_debug
959: THEN
960: l_proc_step := 20;
961: DEBUG(l_proc_name, l_proc_step);
962: DEBUG('Before calling function pay_balance_pkg.get_value');
963: DEBUG(
964: 'l_effective_date: '
965: || TO_CHAR(l_effective_date, 'DD/MON/YYYY')
966: );

Line 971: pay_balance_pkg.get_value(

967: END IF;
968:
969: BEGIN
970: l_balance_value :=
971: pay_balance_pkg.get_value(
972: p_defined_balance_id => p_defined_balance_id
973: ,p_assignment_id => p_assignment_id
974: ,p_virtual_date => l_effective_date
975: );

Line 3945: pay_balance_pkg.get_value(

3941: ,p_effective_end_date => l_effective_end_date
3942: );
3943: ELSE
3944: l_ni_cont_out_earn :=
3945: pay_balance_pkg.get_value(
3946: p_defined_balance_id => i
3947: ,p_assignment_id => p_assignment_id
3948: ,p_virtual_date => l_effective_end_date);
3949:

Line 3952: -- pay_balance_pkg.get_value(

3948: ,p_virtual_date => l_effective_end_date);
3949:
3950: END IF; -- IF NOT p_ptd_balance
3951:
3952: -- pay_balance_pkg.get_value(
3953: -- p_defined_balance_id => i
3954: -- ,p_assignment_id => p_assignment_id
3955: -- ,p_virtual_date => l_effective_end_date);
3956: -- EXCEPTION

Line 4165: pay_balance_pkg.get_value(l_defined_balance_id(i),g_asst_action_id);

4161: THEN
4162: -- For Bug 7297812
4163: l_wps_contribution :=
4164:
4165: pay_balance_pkg.get_value(l_defined_balance_id(i),g_asst_action_id);
4166: -- For 115.29
4167: /* pay_balance_pkg.get_value(
4168: p_defined_balance_id => l_defined_balance_id(i)
4169: ,p_assignment_id => p_assignment_id

Line 4167: /* pay_balance_pkg.get_value(

4163: l_wps_contribution :=
4164:
4165: pay_balance_pkg.get_value(l_defined_balance_id(i),g_asst_action_id);
4166: -- For 115.29
4167: /* pay_balance_pkg.get_value(
4168: p_defined_balance_id => l_defined_balance_id(i)
4169: ,p_assignment_id => p_assignment_id
4170: ,p_virtual_date => l_effective_end_date); */
4171: ELSE

Line 4174: pay_balance_pkg.get_value(l_defined_balance_id(i),g_prev_asst_action_id);

4170: ,p_virtual_date => l_effective_end_date); */
4171: ELSE
4172: -- For Bug 7297812
4173: l_wps_contribution :=
4174: pay_balance_pkg.get_value(l_defined_balance_id(i),g_prev_asst_action_id);
4175: /* pay_balance_pkg.get_value(
4176: p_defined_balance_id => l_defined_balance_id(i)
4177: ,p_assignment_id => p_assignment_id
4178: ,p_virtual_date => l_effective_end_date); */

Line 4175: /* pay_balance_pkg.get_value(

4171: ELSE
4172: -- For Bug 7297812
4173: l_wps_contribution :=
4174: pay_balance_pkg.get_value(l_defined_balance_id(i),g_prev_asst_action_id);
4175: /* pay_balance_pkg.get_value(
4176: p_defined_balance_id => l_defined_balance_id(i)
4177: ,p_assignment_id => p_assignment_id
4178: ,p_virtual_date => l_effective_end_date); */
4179:

Line 4182: -- pay_balance_pkg.get_value(

4178: ,p_virtual_date => l_effective_end_date); */
4179:
4180: END IF; --End if Not p_ptd_balance
4181:
4182: -- pay_balance_pkg.get_value(
4183: -- p_defined_balance_id => l_defined_balance_id(i)
4184: -- ,p_assignment_id => p_assignment_id
4185: -- ,p_virtual_date => l_effective_end_date);
4186: -- EXCEPTION

Line 4359: pay_balance_pkg.get_value(

4355: IF NOT p_ptd_balance
4356: THEN
4357:
4358: l_contributions :=
4359: pay_balance_pkg.get_value(
4360: p_defined_balance_id => l_defined_balance_id
4361: ,p_assignment_action_id => g_asst_action_id);
4362: ELSE
4363: l_contributions :=

Line 4364: pay_balance_pkg.get_value(

4360: p_defined_balance_id => l_defined_balance_id
4361: ,p_assignment_action_id => g_asst_action_id);
4362: ELSE
4363: l_contributions :=
4364: pay_balance_pkg.get_value(
4365: p_defined_balance_id => l_defined_balance_id
4366: ,p_assignment_action_id => g_prev_asst_action_id);
4367:
4368: END IF; --End if Not p_ptd_balance

Line 4546: pay_balance_pkg.get_value(

4542: ,p_effective_end_date => l_effective_end_date
4543: );
4544: ELSE
4545: l_add_yrs_contributions :=
4546: pay_balance_pkg.get_value(
4547: p_defined_balance_id => l_defined_balance_id(i)
4548: ,p_assignment_id => p_assignment_id
4549: ,p_virtual_date => l_effective_end_date);
4550:

Line 4723: pay_balance_pkg.get_value(

4719: IF NOT p_ptd_balance
4720: THEN
4721: -- For Bug 7297812
4722: l_mp_contributions :=
4723: pay_balance_pkg.get_value(
4724: p_defined_balance_id => l_defined_balance_id
4725: ,p_assignment_action_id => g_asst_action_id);
4726: /* -- For 115.29
4727: pay_balance_pkg.get_value(

Line 4727: pay_balance_pkg.get_value(

4723: pay_balance_pkg.get_value(
4724: p_defined_balance_id => l_defined_balance_id
4725: ,p_assignment_action_id => g_asst_action_id);
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: /* get_total_ptd_bal_value(

Line 4741: pay_balance_pkg.get_value(

4737:
4738: ELSE
4739: l_mp_contributions :=
4740: -- For Bug 7297812
4741: pay_balance_pkg.get_value(
4742: p_defined_balance_id => l_defined_balance_id
4743: ,p_assignment_action_id => g_prev_asst_action_id);
4744: /* pay_balance_pkg.get_value(
4745: p_defined_balance_id => l_defined_balance_id

Line 4744: /* pay_balance_pkg.get_value(

4740: -- For Bug 7297812
4741: pay_balance_pkg.get_value(
4742: p_defined_balance_id => l_defined_balance_id
4743: ,p_assignment_action_id => g_prev_asst_action_id);
4744: /* pay_balance_pkg.get_value(
4745: p_defined_balance_id => l_defined_balance_id
4746: ,p_assignment_id => p_assignment_id
4747: ,p_virtual_date => l_effective_end_date); */
4748:

Line 4750: -- pay_balance_pkg.get_value(

4746: ,p_assignment_id => p_assignment_id
4747: ,p_virtual_date => l_effective_end_date); */
4748:
4749: END IF; --End if Not p_ptd_balance
4750: -- pay_balance_pkg.get_value(
4751: -- p_defined_balance_id => l_defined_balance_id
4752: -- ,p_assignment_id => p_assignment_id
4753: -- ,p_virtual_date => l_effective_end_date);
4754: l_total_mp_contributions :=

Line 4923: pay_balance_pkg.get_value(

4919: IF NOT p_ptd_balance
4920: THEN
4921: -- For Bug 7297812
4922: l_contributions :=
4923: pay_balance_pkg.get_value(
4924: p_defined_balance_id => l_defined_balance_id
4925: ,p_assignment_action_id => g_asst_action_id);
4926: /* -- For 115.29
4927: pay_balance_pkg.get_value(

Line 4927: pay_balance_pkg.get_value(

4923: pay_balance_pkg.get_value(
4924: p_defined_balance_id => l_defined_balance_id
4925: ,p_assignment_action_id => g_asst_action_id);
4926: /* -- For 115.29
4927: pay_balance_pkg.get_value(
4928: p_defined_balance_id => l_defined_balance_id
4929: ,p_assignment_id => p_assignment_id
4930: ,p_virtual_date => l_effective_end_date); */
4931:

Line 4941: pay_balance_pkg.get_value(

4937: ); */
4938: ELSE
4939: -- For Bug 7297812
4940: l_contributions :=
4941: pay_balance_pkg.get_value(
4942: p_defined_balance_id => l_defined_balance_id
4943: ,p_assignment_action_id => g_prev_asst_action_id);
4944: /* pay_balance_pkg.get_value(
4945: p_defined_balance_id => l_defined_balance_id

Line 4944: /* pay_balance_pkg.get_value(

4940: l_contributions :=
4941: pay_balance_pkg.get_value(
4942: p_defined_balance_id => l_defined_balance_id
4943: ,p_assignment_action_id => g_prev_asst_action_id);
4944: /* pay_balance_pkg.get_value(
4945: p_defined_balance_id => l_defined_balance_id
4946: ,p_assignment_id => p_assignment_id
4947: ,p_virtual_date => l_effective_end_date); */
4948:

Line 4951: -- pay_balance_pkg.get_value(

4947: ,p_virtual_date => l_effective_end_date); */
4948:
4949: END IF; --End if Not p_ptd_balance
4950:
4951: -- pay_balance_pkg.get_value(
4952: -- p_defined_balance_id => l_defined_balance_id
4953: -- ,p_assignment_id => p_assignment_id
4954: -- ,p_virtual_date => l_effective_end_date);
4955: l_total_contributions :=

Line 5110: pay_balance_pkg.get_value(

5106: IF NOT p_ptd_balance -- For bug 5941475
5107: THEN
5108: -- For Bug 7297812
5109: l_contributions :=
5110: pay_balance_pkg.get_value(
5111: p_defined_balance_id => l_defined_balance_id
5112: ,p_assignment_action_id => g_asst_action_id);
5113: /* -- For 115.29
5114: pay_balance_pkg.get_value(

Line 5114: pay_balance_pkg.get_value(

5110: pay_balance_pkg.get_value(
5111: p_defined_balance_id => l_defined_balance_id
5112: ,p_assignment_action_id => g_asst_action_id);
5113: /* -- For 115.29
5114: pay_balance_pkg.get_value(
5115: p_defined_balance_id => l_defined_balance_id
5116: ,p_assignment_id => p_assignment_id
5117: ,p_virtual_date => l_effective_end_date); */
5118:

Line 5128: pay_balance_pkg.get_value(

5124: ); */
5125: ELSE
5126: -- For Bug 7297812
5127: l_contributions :=
5128: pay_balance_pkg.get_value(
5129: p_defined_balance_id => l_defined_balance_id
5130: ,p_assignment_action_id => g_prev_asst_action_id);
5131:
5132: /* pay_balance_pkg.get_value(

Line 5132: /* pay_balance_pkg.get_value(

5128: pay_balance_pkg.get_value(
5129: p_defined_balance_id => l_defined_balance_id
5130: ,p_assignment_action_id => g_prev_asst_action_id);
5131:
5132: /* pay_balance_pkg.get_value(
5133: p_defined_balance_id => l_defined_balance_id
5134: ,p_assignment_id => p_assignment_id
5135: ,p_virtual_date => l_effective_end_date); */
5136:

Line 5291: pay_balance_pkg.get_value(

5287: ,p_effective_end_date => l_effective_end_date
5288: );
5289: ELSE
5290: l_ni_e_earnings :=
5291: pay_balance_pkg.get_value(
5292: p_defined_balance_id => l_defined_balance_id
5293: ,p_assignment_id => p_assignment_id
5294: ,p_virtual_date => l_effective_end_date);
5295:

Line 5297: -- pay_balance_pkg.get_value(

5293: ,p_assignment_id => p_assignment_id
5294: ,p_virtual_date => l_effective_end_date);
5295:
5296: END IF; --End if Not p_ptd_balance
5297: -- pay_balance_pkg.get_value(
5298: -- p_defined_balance_id => l_defined_balance_id
5299: -- ,p_assignment_id => p_assignment_id
5300: -- ,p_virtual_date => l_effective_end_date);
5301: -- EXCEPTION

Line 5610: pay_balance_pkg.get_value(

5606: THEN
5607: -- BEGIN
5608: -- For Bug 7297812
5609: l_earnings :=
5610: pay_balance_pkg.get_value(
5611: p_defined_balance_id => l_pen_defined_balance_id
5612: ,p_assignment_action_id => g_asst_action_id);
5613: /* -- For 115.29
5614: pay_balance_pkg.get_value(

Line 5614: pay_balance_pkg.get_value(

5610: pay_balance_pkg.get_value(
5611: p_defined_balance_id => l_pen_defined_balance_id
5612: ,p_assignment_action_id => g_asst_action_id);
5613: /* -- For 115.29
5614: pay_balance_pkg.get_value(
5615: p_defined_balance_id => l_pen_defined_balance_id
5616: ,p_assignment_id => p_assignment_id
5617: ,p_virtual_date => l_effective_end_date); */
5618:

Line 5631: pay_balance_pkg.get_value(

5627: IF l_check_current_balance = 'Y' AND g_prev_asst_action_id IS NOT NULL
5628: THEN
5629: -- For Bug 7297812
5630: l_current_earnings :=
5631: pay_balance_pkg.get_value(
5632: p_defined_balance_id => l_defined_balance_id
5633: ,p_assignment_action_id => g_prev_asst_action_id);
5634: /* pay_balance_pkg.get_value(
5635: p_defined_balance_id => l_defined_balance_id

Line 5634: /* pay_balance_pkg.get_value(

5630: l_current_earnings :=
5631: pay_balance_pkg.get_value(
5632: p_defined_balance_id => l_defined_balance_id
5633: ,p_assignment_action_id => g_prev_asst_action_id);
5634: /* pay_balance_pkg.get_value(
5635: p_defined_balance_id => l_defined_balance_id
5636: ,p_assignment_id => p_assignment_id
5637: ,p_virtual_date => l_effective_end_date); */
5638:

Line 5646: -- pay_balance_pkg.get_value(

5642: END IF;
5643:
5644: END IF; --End if l_check_current_balance = 'Y'
5645:
5646: -- pay_balance_pkg.get_value(
5647: -- p_defined_balance_id => l_defined_balance_id
5648: -- ,p_assignment_id => p_assignment_id
5649: -- ,p_virtual_date => l_effective_end_date);
5650: -- EXCEPTION

Line 5779: pay_balance_pkg.get_value(

5775: THEN
5776: -- BEGIN
5777: -- For Bug 7297812
5778: l_earnings :=
5779: pay_balance_pkg.get_value(
5780: p_defined_balance_id => l_pen_defined_balance_id
5781: ,p_assignment_action_id => g_asst_action_id);
5782: /* -- For 115.29
5783: pay_balance_pkg.get_value(

Line 5783: pay_balance_pkg.get_value(

5779: pay_balance_pkg.get_value(
5780: p_defined_balance_id => l_pen_defined_balance_id
5781: ,p_assignment_action_id => g_asst_action_id);
5782: /* -- For 115.29
5783: pay_balance_pkg.get_value(
5784: p_defined_balance_id => l_pen_defined_balance_id
5785: ,p_assignment_id => p_assignment_id
5786: ,p_virtual_date => l_effective_end_date); */
5787: /* get_total_ptd_bal_value(

Line 5799: pay_balance_pkg.get_value(

5795: IF l_check_current_balance = 'Y' AND g_prev_asst_action_id IS NOT NULL
5796: THEN
5797: -- For Bug 7297812
5798: l_current_earnings :=
5799: pay_balance_pkg.get_value(
5800: p_defined_balance_id => l_defined_balance_id
5801: ,p_assignment_action_id => g_prev_asst_action_id);
5802: /* pay_balance_pkg.get_value(
5803: p_defined_balance_id => l_defined_balance_id

Line 5802: /* pay_balance_pkg.get_value(

5798: l_current_earnings :=
5799: pay_balance_pkg.get_value(
5800: p_defined_balance_id => l_defined_balance_id
5801: ,p_assignment_action_id => g_prev_asst_action_id);
5802: /* pay_balance_pkg.get_value(
5803: p_defined_balance_id => l_defined_balance_id
5804: ,p_assignment_id => p_assignment_id
5805: ,p_virtual_date => l_effective_end_date); */
5806:

Line 5814: -- pay_balance_pkg.get_value(

5810: END IF;
5811:
5812: END IF; --End if l_check_current_balance = 'Y'
5813:
5814: -- pay_balance_pkg.get_value(
5815: -- p_defined_balance_id => l_defined_balance_id
5816: -- ,p_assignment_id => p_assignment_id
5817: -- ,p_virtual_date => l_effective_end_date);
5818: -- EXCEPTION

Line 5871: -- pay_balance_pkg.get_value(

5867: -- ,p_defined_balance_id => l_defined_balance_id
5868: -- ,p_effective_start_date => g_effective_start_date
5869: -- ,p_effective_end_date => l_effective_end_date
5870: -- );
5871: -- pay_balance_pkg.get_value(
5872: -- p_defined_balance_id => l_defined_balance_id
5873: -- ,p_assignment_id => p_assignment_id
5874: -- ,p_virtual_date => l_effective_end_date);
5875: -- EXCEPTION

Line 5973: -- pay_balance_pkg.get_value(

5969: -- ,p_defined_balance_id => l_defined_balance_id
5970: -- ,p_effective_start_date => g_effective_start_date
5971: -- ,p_effective_end_date => l_effective_end_date
5972: -- );
5973: -- pay_balance_pkg.get_value(
5974: -- p_defined_balance_id => l_defined_balance_id
5975: -- ,p_assignment_id => p_assignment_id
5976: -- ,p_virtual_date => l_effective_end_date);
5977: -- EXCEPTION

Line 6046: -- pay_balance_pkg.get_value(

6042: -- ,p_defined_balance_id => l_defined_balance_id
6043: -- ,p_effective_start_date => g_effective_start_date
6044: -- ,p_effective_end_date => l_effective_end_date
6045: -- );
6046: -- pay_balance_pkg.get_value(
6047: -- p_defined_balance_id => l_defined_balance_id
6048: -- ,p_assignment_id => p_assignment_id
6049: -- ,p_virtual_date => l_effective_end_date);
6050: -- EXCEPTION

Line 6121: -- pay_balance_pkg.get_value(

6117: -- ,p_defined_balance_id => l_defined_balance_id
6118: -- ,p_effective_start_date => g_effective_start_date
6119: -- ,p_effective_end_date => l_effective_end_date
6120: -- );
6121: -- pay_balance_pkg.get_value(
6122: -- p_defined_balance_id => l_defined_balance_id
6123: -- ,p_assignment_id => p_assignment_id
6124: -- ,p_virtual_date => l_effective_end_date);
6125: -- EXCEPTION

Line 6173: pay_balance_pkg.get_value(

6169: THEN
6170: -- BEGIN
6171: -- For Bug 7297812
6172: l_earnings :=
6173: pay_balance_pkg.get_value(
6174: p_defined_balance_id => l_pen_defined_balance_id
6175: ,p_assignment_action_id => g_asst_action_id);
6176: /* -- For 115.29
6177: pay_balance_pkg.get_value(

Line 6177: pay_balance_pkg.get_value(

6173: pay_balance_pkg.get_value(
6174: p_defined_balance_id => l_pen_defined_balance_id
6175: ,p_assignment_action_id => g_asst_action_id);
6176: /* -- For 115.29
6177: pay_balance_pkg.get_value(
6178: p_defined_balance_id => l_pen_defined_balance_id
6179: ,p_assignment_id => p_assignment_id
6180: ,p_virtual_date => l_effective_end_date); */
6181:

Line 6194: pay_balance_pkg.get_value(

6190: IF l_check_current_balance = 'Y' AND g_prev_asst_action_id IS NOT NULL
6191: THEN
6192: -- For Bug 7297812
6193: l_current_earnings :=
6194: pay_balance_pkg.get_value(
6195: p_defined_balance_id => l_defined_balance_id
6196: ,p_assignment_action_id => g_prev_asst_action_id);
6197:
6198: /* pay_balance_pkg.get_value(

Line 6198: /* pay_balance_pkg.get_value(

6194: pay_balance_pkg.get_value(
6195: p_defined_balance_id => l_defined_balance_id
6196: ,p_assignment_action_id => g_prev_asst_action_id);
6197:
6198: /* pay_balance_pkg.get_value(
6199: p_defined_balance_id => l_defined_balance_id
6200: ,p_assignment_id => p_assignment_id
6201: ,p_virtual_date => l_effective_end_date); */
6202:

Line 6246: pay_balance_pkg.get_value(

6242: THEN
6243: -- BEGIN
6244: -- For Bug 7297812
6245: l_earnings :=
6246: pay_balance_pkg.get_value(
6247: p_defined_balance_id => l_pen_defined_balance_id
6248: ,p_assignment_action_id => g_asst_action_id);
6249: /* -- For 115.29
6250: pay_balance_pkg.get_value(

Line 6250: pay_balance_pkg.get_value(

6246: pay_balance_pkg.get_value(
6247: p_defined_balance_id => l_pen_defined_balance_id
6248: ,p_assignment_action_id => g_asst_action_id);
6249: /* -- For 115.29
6250: pay_balance_pkg.get_value(
6251: p_defined_balance_id => l_pen_defined_balance_id
6252: ,p_assignment_id => p_assignment_id
6253: ,p_virtual_date => l_effective_end_date); */
6254:

Line 6267: pay_balance_pkg.get_value(

6263: IF l_check_current_balance = 'Y' AND g_prev_asst_action_id IS NOT NULL
6264: THEN
6265: -- For Bug 7297812
6266: l_current_earnings :=
6267: pay_balance_pkg.get_value(
6268: p_defined_balance_id => l_defined_balance_id
6269: ,p_assignment_action_id => g_prev_asst_action_id);
6270: /* pay_balance_pkg.get_value(
6271: p_defined_balance_id => l_defined_balance_id

Line 6270: /* pay_balance_pkg.get_value(

6266: l_current_earnings :=
6267: pay_balance_pkg.get_value(
6268: p_defined_balance_id => l_defined_balance_id
6269: ,p_assignment_action_id => g_prev_asst_action_id);
6270: /* pay_balance_pkg.get_value(
6271: p_defined_balance_id => l_defined_balance_id
6272: ,p_assignment_id => p_assignment_id
6273: ,p_virtual_date => l_effective_end_date); */
6274: