[Home] [Help]
22: -- Record used store the Superannuation details of the employee
23:
24: TYPE spr_flag_record IS RECORD
25: (
26: k_assignment_id per_all_assignments_f.assignment_id%TYPE,
27: tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE
28: );
29:
30: TYPE spr_flag_table IS TABLE OF spr_flag_record INDEX BY BINARY_INTEGER;
88: , decode(sign(nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) - c_report_end_date),
89: 1,null,pps.actual_termination_date) actual_termination_date
90: , decode(eev0.screen_entry_value,'YS','Y','YI','Y','YC','Y','NN','N','YN','N','Y','N','N','N',Null) /*bug7270073*/
91: FROM per_people_f pap /* Bug 4925794 */
92: , per_all_assignments_f paa,/*Bug 3012794*/
93: hr_soft_coding_keyflex hsc,
94: per_periods_of_service pps
95: , pay_element_entries_f pee
96: , pay_element_types_f pet
274: AND pev1.effective_start_date <= c_report_end_date
275: )
276: AND c_report_end_date BETWEEN pet.effective_start_date AND pet.effective_end_date
277: AND c_report_end_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
278: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
279: l_australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE;
280: l_tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE;
281: l_fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE;
282: l_basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE;
424: -- It uses the plsql table, searches the assignment_id and returns the value
425: -- of the flag that is passed as the parameter.
426: ------------------------------------------------------------------------------+
427:
428: FUNCTION get_tfn_flag_values(p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
429: p_flag_name in varchar2) RETURN varchar2 IS
430: BEGIN
431:
432: hr_utility.trace('Start of get_tfn_flag_values function');