66:
67: --
68: -- Uses :
69: -- pay_au_terminations
70: -- hr_utility
71: --
72: ------------------------------------------------------------------------------------------------
73: function ETP_prepayment_information
74: (p_assignment_id in number
302:
303:
304:
305: begin
306: hr_utility.trace('-----------------------------------------');
307: hr_utility.set_location('Entering : '||l_procedure, 1);
308:
309: Lv_result:= pay_au_Terminations.etp_prepost_ratios
310: (p_assignment_id
303:
304:
305: begin
306: hr_utility.trace('-----------------------------------------');
307: hr_utility.set_location('Entering : '||l_procedure, 1);
308:
309: Lv_result:= pay_au_Terminations.etp_prepost_ratios
310: (p_assignment_id
311: ,p_hire_date
325: -- its just getting populated for the first etp element processed
326:
327: /* 6470561 */
328:
329: hr_utility.set_location('Leaving : '||l_procedure, 1);
330: return(1);
331:
332: Exception
333: when Others then
481: and paa.payroll_action_id=ppa.payroll_action_id;
482: begin
483:
484: begin
485: hr_utility.trace('-----------------------------------------');
486: hr_utility.set_location('Entering : '||l_procedure, 1);
487:
488:
489:
482: begin
483:
484: begin
485: hr_utility.trace('-----------------------------------------');
486: hr_utility.set_location('Entering : '||l_procedure, 1);
487:
488:
489:
490: Lv_Element_Name := 'Superannuation Rollover on Termination';
779: end if;
780:
781: exception
782: when No_DatA_Found Then
783: hr_utility.trace('is cursor not found tarun ');
784: p_ETP_Payment := 0;
785: end;
786: /* 6470561 */
787: hr_utility.set_location('Leaving : '||l_procedure, 1);
783: hr_utility.trace('is cursor not found tarun ');
784: p_ETP_Payment := 0;
785: end;
786: /* 6470561 */
787: hr_utility.set_location('Leaving : '||l_procedure, 1);
788:
789: return(1);
790: Exception
791: When Others then
788:
789: return(1);
790: Exception
791: When Others then
792: hr_utility.set_location('exception in Leaving : '||l_procedure, 1);
793: return(0);
794: end ETP_payment_information;
795:
796: ------------------------------Function to get Invalidity Balances----------------------------------------