490: ,null insurance_abp
491: ,null risk_fund
492: FROM
493: per_all_assignments_f paa
494: ,hr_soft_coding_keyflex scl_flx
495: ,per_assignment_status_types asg_stat
496: ,per_assignment_extra_info ee_si
497: WHERE paa.person_id = lp_person_id
498: and paa.assignment_id = lp_assignment_id
525: ,null insurance_abp
526: ,null risk_fund
527: FROM
528: per_all_assignments_f paa
529: ,hr_soft_coding_keyflex scl_flx
530: ,per_assignment_status_types asg_stat
531: ,per_assignment_extra_info ee_si
532: WHERE paa.person_id = lp_person_id
533: AND paa.assignment_id = lp_assignment_id
558: ,ee_cadans.aei_information6 insurance_abp
559: ,ee_cadans.aei_information7 risk_fund
560: FROM
561: per_all_assignments_f paa
562: ,hr_soft_coding_keyflex scl_flx
563: ,per_assignment_status_types asg_stat
564: ,per_assignment_extra_info ee_cadans
565: ,per_assignment_extra_info ee_si
566: WHERE paa.person_id = lp_person_id
598: ,ee_cadans.aei_information6 insurance_abp
599: ,ee_cadans.aei_information7 risk_fund
600: FROM
601: per_all_assignments_f paa
602: ,hr_soft_coding_keyflex scl_flx
603: ,per_assignment_status_types asg_stat
604: ,per_assignment_extra_info ee_cadans
605: ,per_assignment_extra_info ee_si
606: WHERE paa.person_id = lp_person_id
1877: ,scl_flx.SEGMENT6 Work_Pattern
1878: FROM
1879: per_all_assignments_f paa
1880: ,per_all_people_f pap
1881: ,hr_soft_coding_keyflex scl_flx
1882: WHERE paa.business_group_id = lp_business_group_id
1883: and paa.person_id
1884: BETWEEN lp_start_person_id AND lp_end_person_id
1885: and (paa.payroll_id = lp_payroll_id OR lp_payroll_id IS NULL)