[Home] [Help]
414: assignment_action_id assignment_action_id
415: from pay_payroll_actions ppa,
416: pay_assignment_actions paa,
417: per_people_f pap,
418: per_assignments_f paf
419: where paa.payroll_action_id = ppa.payroll_action_id
420: and pap.person_id = paf.person_id
421: and paa.assignment_id = paf.assignment_id
422: and paa.tax_unit_id=nvl(c_registered_employer, paa.tax_unit_id)
428: and ppa.effective_date between pap.effective_start_date and pap.effective_end_date /* 4729052 */
429: AND (paa.source_action_id IS NULL
430: OR (paa.source_action_id IS NOT NULL AND ppa.run_type_id IS NULL))
431: and paf.effective_end_date = (select max(effective_end_date) /* 4729052 */
432: From per_assignments_f iipaf
433: WHERE iipaf.assignment_id = paf.assignment_id
434: and iipaf.effective_end_date >= c_start_date
435: and iipaf.effective_start_date <= c_end_date)
436:
582: paa.tax_unit_id,
583: paa.source_action_id master_action_id,
584: paa2.tax_unit_id master_tax_unit_id
585: from per_people_f pap,
586: per_assignments_f paaf,
587: pay_payroll_actions ppa,
588: pay_payroll_actions ppa1,
589: pay_assignment_actions paa,
590: pay_assignment_actions paa2,
612: and ppa1.action_type in ('R','Q','I','B','V')
613: and ( paa.tax_unit_id = p_legal_employer or p_legal_employer is null)
614: and ppa1.effective_date between p_archive_start_date and p_archive_end_date
615: and paaf.effective_end_date = (select max(effective_end_date)
616: From per_assignments_f iipaf
617: WHERE iipaf.assignment_id = paaf.assignment_id
618: and iipaf.effective_end_date >= p_archive_start_date
619: and iipaf.effective_start_date <= p_archive_end_date)
620: order by paaf.assignment_id, paa.assignment_action_id, paa.tax_unit_id, paa.source_action_id, paa2.tax_unit_id;
814: hoi.org_information2 dge_legal_employer,
815: hoi.org_information3 dge_group_name,
816: hl.meaning state_desc
817: from per_people_f pap,
818: per_assignments_f paaf,
819: pay_payroll_actions ppa,
820: pay_payroll_actions ppa1,
821: pay_assignment_actions paa,
822: pay_assignment_actions paa2,
853: and ppa.business_group_id = c_business_group_id
854: and ppa1.action_type in ('R','Q','I','B','V')
855: and ppa1.effective_date between c_start_date and c_end_date
856: and paaf.effective_end_date = (select max(effective_end_date)
857: From per_assignments_f iipaf
858: WHERE iipaf.assignment_id = paaf.assignment_id
859: and iipaf.effective_end_date >= c_start_date
860: and iipaf.effective_start_date <= c_end_date)
861: /* and c_end_date between pap.effective_start_date and pap.effective_end_date */