APPS.PAY_AU_TFN_MAGTAPE_FLAGS dependencies on PER_PERIODS_OF_SERVICE

Line 94: per_periods_of_service pps

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

Line 128: from per_periods_of_service pps1

124: AND hsc.segment1 = c_legal_employer_id
125: AND pee.assignment_id = paa.assignment_id
126: AND pps.person_id = paa.person_id
127: AND pps.date_start= (select max(pps1.date_start)
128: from per_periods_of_service pps1
129: where pps1.person_id=pps.person_id
130: AND pps1.date_start <= c_report_end_date
131: ) /*Bug2751008*/
132: AND ( pee.entry_information_category = 'AU_TAX DEDUCTIONS' and

Line 289: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

285: l_declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE;
286: l_rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE;
287: l_tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE;
288: l_effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE;
289: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
290: l_current_or_terminated varchar2(1);
291: l_tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE;
292: l_senior_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE; /*bug7270073*/
293: