[Home] [Help]
23: ** 04-DEC-2002 Ragovind 115.10 Added NOCOPY for the functions etp_payment_information,etp_prepayment_information
24: ** 15-May-2003 Ragovind 115.11 Bug#2819479 - ETP Pre/Post Enhancement.
25: ** 23-JUL-2003 Nanuradh 115.12 Bug#2984390 - Added an extra parameter to the function call etp_prepost_ratios - ETP Pre/post Enhancement
26: ** 22-Apr-2005 ksingla 115.13 Bug#4177679 -Added an extra parameter to the function call etp_prepost_ratios .
27: ** 25-Apr-2005 abhargav 115.14 Bug#4322599 - For ETP Tax modified the package hr_aubal call,
28: ** now calling the package in action mode rather then date mode
29: ** 21-Nov-2007 tbakashi 115.15 Bug#6470561 - STATUTORY UPDATE: MUTIPLE ETP IMPACT ON TERMINATION REPORT
30: ** ============== Formula Fuctions ====================
31: ** Package contains Reporting Details for the Termination
827: close get_date_earned;
828:
829:
830:
831: lv_invalidity_component := hr_aubal.calc_asg_ptd_action
832: (P_Assignment_Action_id
833: ,Lv_balance_type_id_1
834: ,l_end_date)
835: +
832: (P_Assignment_Action_id
833: ,Lv_balance_type_id_1
834: ,l_end_date)
835: +
836: hr_aubal.calc_asg_ptd_action
837: (P_Assignment_Action_id
838: ,Lv_balance_type_id_2
839: ,l_end_date);
840:
917: fetch get_date_earned into l_end_date;
918: close get_date_earned;
919:
920:
921: l_etp_excluded_tfree_amt := nvl(hr_aubal.calc_asg_ptd_action
922: (P_Assignment_Action_id
923: ,Lv_balance_type_id_1
924: ,l_end_date),0);
925:
922: (P_Assignment_Action_id
923: ,Lv_balance_type_id_1
924: ,l_end_date),0);
925:
926: l_etp_excluded_taxable_amt := nvl(hr_aubal.calc_asg_ptd_action
927: (P_Assignment_Action_id
928: ,Lv_balance_type_id_2
929: ,l_end_date),0);
930:
927: (P_Assignment_Action_id
928: ,Lv_balance_type_id_2
929: ,l_end_date),0);
930:
931: l_etp_excluded_amt := nvl(hr_aubal.calc_asg_ptd_action
932: (P_Assignment_Action_id
933: ,Lv_balance_type_id_3
934: ,l_end_date),0);
935: