[Home] [Help]
712: assignment_action_id assignment_action_id
713: from pay_payroll_actions ppa,
714: pay_assignment_actions paa,
715: per_people_f pap,
716: per_assignments_f paf
717: where paa.payroll_action_id = ppa.payroll_action_id
718: and pap.person_id = paf.person_id
719: and paa.assignment_id = paf.assignment_id
720: and paa.tax_unit_id=nvl(c_registered_employer, paa.tax_unit_id)
726: and ppa.effective_date between pap.effective_start_date and pap.effective_end_date /* 4729052 */
727: AND (paa.source_action_id IS NULL
728: OR (paa.source_action_id IS NOT NULL AND ppa.run_type_id IS NULL))
729: and paf.effective_end_date = (select max(effective_end_date) /* 4729052 */
730: From per_assignments_f iipaf
731: WHERE iipaf.assignment_id = paf.assignment_id
732: and iipaf.effective_end_date >= c_start_date
733: and iipaf.effective_start_date <= c_end_date)
734:
883: paa.tax_unit_id,
884: paa.source_action_id master_action_id,
885: paa2.tax_unit_id master_tax_unit_id
886: from per_people_f pap,
887: per_assignments_f paaf,
888: pay_payroll_actions ppa,
889: pay_payroll_actions ppa1,
890: pay_assignment_actions paa,
891: pay_assignment_actions paa2,
913: and ppa1.action_type in ('R','Q','I','B','V')
914: and ( paa.tax_unit_id = p_legal_employer or p_legal_employer is null)
915: and ppa1.effective_date between p_archive_start_date and p_archive_end_date
916: and paaf.effective_end_date = (select max(effective_end_date)
917: From per_assignments_f iipaf
918: WHERE iipaf.assignment_id = paaf.assignment_id
919: and iipaf.effective_end_date >= p_archive_start_date
920: and iipaf.effective_start_date <= p_archive_end_date)
921: order by paaf.assignment_id, paa.assignment_action_id, paa.tax_unit_id, paa.source_action_id, paa2.tax_unit_id;
1115: hoi.org_information2 dge_legal_employer,
1116: hoi.org_information3 dge_group_name,
1117: hl.meaning state_desc
1118: from per_people_f pap,
1119: per_assignments_f paaf,
1120: pay_payroll_actions ppa,
1121: pay_payroll_actions ppa1,
1122: pay_assignment_actions paa,
1123: pay_assignment_actions paa2,
1154: and ppa.business_group_id = c_business_group_id
1155: and ppa1.action_type in ('R','Q','I','B','V')
1156: and ppa1.effective_date between c_start_date and c_end_date
1157: and paaf.effective_end_date = (select max(effective_end_date)
1158: From per_assignments_f iipaf
1159: WHERE iipaf.assignment_id = paaf.assignment_id
1160: and iipaf.effective_end_date >= c_start_date
1161: and iipaf.effective_start_date <= c_end_date)
1162: /* and c_end_date between pap.effective_start_date and pap.effective_end_date */