57:
58: --
59: -- Uses :
60: -- pay_au_terminations
61: -- hr_utility
62: --
63: ------------------------------------------------------------------------------------------------
64: function ETP_prepayment_information
65: (p_assignment_id in number
233:
234:
235:
236: begin
237: hr_utility.trace('-----------------------------------------');
238: hr_utility.set_location('Entering : '||l_procedure, 1);
239:
240: Lv_result:= pay_au_Terminations.etp_prepost_ratios
241: (p_assignment_id
234:
235:
236: begin
237: hr_utility.trace('-----------------------------------------');
238: hr_utility.set_location('Entering : '||l_procedure, 1);
239:
240: Lv_result:= pay_au_Terminations.etp_prepost_ratios
241: (p_assignment_id
242: ,p_hire_date
256: -- its just getting populated for the first etp element processed
257:
258: /* 6470561 */
259:
260: hr_utility.set_location('Leaving : '||l_procedure, 1);
261: return(1);
262:
263: Exception
264: when Others then
374: and paa.payroll_action_id=ppa.payroll_action_id;
375: begin
376:
377: begin
378: hr_utility.trace('-----------------------------------------');
379: hr_utility.set_location('Entering : '||l_procedure, 1);
380:
381:
382:
375: begin
376:
377: begin
378: hr_utility.trace('-----------------------------------------');
379: hr_utility.set_location('Entering : '||l_procedure, 1);
380:
381:
382:
383: Lv_Element_Name := 'Superannuation Rollover on Termination';
581: End if;
582:
583: exception
584: when No_DatA_Found Then
585: hr_utility.trace('is cursor not found tarun ');
586: p_ETP_Payment := 0;
587: end;
588: /* 6470561 */
589: hr_utility.set_location('Leaving : '||l_procedure, 1);
585: hr_utility.trace('is cursor not found tarun ');
586: p_ETP_Payment := 0;
587: end;
588: /* 6470561 */
589: hr_utility.set_location('Leaving : '||l_procedure, 1);
590:
591: return(1);
592: Exception
593: When Others then
590:
591: return(1);
592: Exception
593: When Others then
594: hr_utility.set_location('exception in Leaving : '||l_procedure, 1);
595: return(0);
596: end ETP_payment_information;
597:
598: ------------------------------Function to get Invalidity Balances----------------------------------------