[Home] [Help]
3089: ,paf.effective_end_date
3090: ,paf.payroll_id
3091: ,hsc.segment1 tax_unit_id
3092: FROM per_assignments_f paf
3093: ,hr_soft_coding_keyflex hsc
3094: WHERE paf.assignment_id = c_assignment_id
3095: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3096: AND hsc.segment1 LIKE c_tax_unit_id
3097: AND to_char(paf.assignment_status_type_id) NOT LIKE c_f_status_id
5167: ,pad.date_from date_from/*Bug 2977533 */
5168: ,decode(pps.pds_information1, 'AU_D',nvl(pps.pds_information11,'000 000 000'),pev.screen_entry_value) etp_death_benefit_tfn /*Bug#8315198*/
5169: from hr_organization_information hoi,
5170: hr_organization_units hou,
5171: hr_soft_coding_keyflex hsc,
5172: pay_element_types_f pet,
5173: pay_input_values_f piv,
5174: pay_element_links_f pel,
5175: pay_element_entries_f pee,
7307: ,to_char(paa.effective_end_date,'DDMMYYYY') -- Bug 2610141
7308: ,pps.pds_information1 termination_type --Bug 8315198
7309: from hr_organization_information hoi,
7310: hr_organization_units hou,
7311: hr_soft_coding_keyflex hsc,
7312: hr_locations hlc, /* Bug No : 2263587 */
7313: per_all_assignments_f paa,
7314: per_all_assignments_f paaf, /* Bug : 2610141 */
7315: per_all_people_f pap,
7355: /* End of Bug# 2448441 */
7356: and (paa.effective_start_date, paaf.effective_start_date)
7357: = (select max(a.effective_Start_date),min(a.effective_start_date) -- Bug 2610141
7358: from per_all_assignments_f a
7359: , hr_soft_coding_keyflex hsc1 --Added for bug 4177679
7360: where a.assignment_id = paa.assignment_id
7361: and hsc1.soft_coding_keyflex_id = a.soft_coding_keyflex_id --Added for bug 4177679
7362: and hsc1.segment1= p_registered_employer --Added for bug 4177679
7363: and nvl(pps.actual_termination_date,p_year_end)
8217: ,c_year_end pay_payroll_actions.effective_date%type
8218: ) is
8219: select paaf.assignment_id
8220: from per_assignments_f paaf,
8221: hr_soft_coding_keyflex hsck
8222: where paaf.assignment_id = c_assignment_id
8223: and paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
8224: and paaf.effective_start_date <= c_year_end
8225: and paaf.effective_end_date >= c_year_start
8256: ,c_year_start pay_payroll_actions.effective_date%type
8257: ) is
8258: select hsck.segment1
8259: from per_assignments_f paaf,
8260: hr_soft_coding_keyflex hsck
8261: where paaf.assignment_id = c_assignment_id
8262: and paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
8263: and paaf.effective_start_date <= c_year_end
8264: and paaf.effective_end_date >= c_year_start