[Home] [Help]
883: into l_max_aaid
884: from pay_assignment_actions paa1,
885: per_all_assignments_f paf2,
886: pay_payroll_actions ppa2,
887: pay_action_classifications pac2
888: where paf2.person_id = l_person_id
889: and paa1.assignment_id = paf2.assignment_id
890: and paa1.tax_unit_id = l_tax_unit_id
891: and paa1.payroll_action_id = ppa2.payroll_action_id
895: and paf2.effective_end_date
896: and ppa2.effective_date between l_period_start and
897: l_period_end
898: and not exists (select ''
899: FROM pay_action_classifications pac,
900: pay_payroll_actions ppa,
901: pay_assignment_actions paa,
902: per_all_assignments_f paf1
903: WHERE paf1.person_id = l_person_id
2092: select paa.assignment_action_id
2093: from pay_assignment_actions paa,
2094: per_all_assignments_f paf,
2095: pay_payroll_actions ppa,
2096: pay_action_classifications pac
2097: where paf.person_id = p_person_id
2098: and paa.assignment_id = paf.assignment_id
2099: and paa.tax_unit_id = l_tax_unit_id
2100: and paa.payroll_action_id = ppa.payroll_action_id
3506: select paa.assignment_action_id
3507: from pay_assignment_actions paa,
3508: per_all_assignments_f paf,
3509: pay_payroll_actions ppa,
3510: pay_action_classifications pac
3511: where paf.person_id = p_person_id
3512: and paa.assignment_id = paf.assignment_id
3513: and paa.tax_unit_id = l_tax_unit_id
3514: and paa.payroll_action_id = ppa.payroll_action_id
3631: where paa1.assignment_id = paf2.assignment_id
3632: and paa1.tax_unit_id = l_tax_unit_id
3633: and (paa1.action_sequence , paf2.person_id) =
3634: (SELECT MAX(paa.action_sequence), paf.person_id
3635: FROM pay_action_classifications pac,
3636: pay_payroll_actions ppa,
3637: pay_assignment_actions paa,
3638: per_all_assignments_f paf1,
3639: per_all_assignments_f paf