[Home] [Help]
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
97: , pay_input_values_f piv0
98: , pay_element_entry_values_f eev0
125: AND hsc.segment1 = c_legal_employer_id
126: AND pee.assignment_id = paa.assignment_id
127: AND pps.person_id = paa.person_id
128: AND pps.date_start= (select max(pps1.date_start)
129: from per_periods_of_service pps1
130: where pps1.person_id=pps.person_id
131: AND pps1.date_start <= c_report_end_date
132: ) /*Bug2751008*/
133: AND ( pee.entry_information_category = 'AU_TAX DEDUCTIONS' and
289: l_declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE;
290: l_rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE;
291: l_tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE;
292: l_effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE;
293: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
294: l_current_or_terminated varchar2(1);
295: l_tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE;
296: l_senior_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE; /*bug7270073*/
297: l_super_assignment_id per_all_assignments_f.assignment_id%TYPE;