[Home] [Help]
639: --
640: -- This cursor would be used for W2, SQWL and 1099R mag
641: --
642: CURSOR get_mmref_person_name
643: (c_assignment_id per_all_assignments_f.assignment_id%type,
644: c_effective_date date)
645: IS
646: SELECT ppf.full_name ,
647: ppf.employee_number
644: c_effective_date date)
645: IS
646: SELECT ppf.full_name ,
647: ppf.employee_number
648: from per_all_assignments_f assign
649: , per_all_people_f ppf
650: where ASSIGN.assignment_id = c_assignment_id
651: and c_effective_date BETWEEN ASSIGN.effective_start_date
652: AND ASSIGN.effective_end_date
658: --
659: -- This cursor would be used for W2, SQWL, 1099R mag
660: --
661: CURSOR get_mmref_name_address
662: (c_assignment_id per_all_assignments_f.assignment_id%type,
663: c_effective_date date)
664: IS
665: SELECT ppf.full_name ,
666: ppf.employee_number ,
676: fttl.territory_short_name,
677: addr.region_1 ,
678: addr.region_2 ,
679: 'Y' valid_address
680: from per_all_assignments_f assign
681: , per_addresses addr
682: , per_all_people_f ppf
683: , fnd_territories_tl fttl
684: , fnd_territories ftt
704: -- for the given effective_date. This cursor will fetch employee current
705: -- primary address
706: --
707: CURSOR get_mmref_name_address_eod
708: (c_assignment_id per_all_assignments_f.assignment_id%type)
709: IS
710: SELECT ppf.full_name ,
711: ppf.employee_number ,
712: addr.address_line1 ,
721: fttl.territory_short_name,
722: addr.region_1 ,
723: addr.region_2 ,
724: 'Y' valid_address
725: FROM per_all_assignments_f ASSIGN
726: , per_addresses ADDR
727: , per_all_people_f PPF
728: , fnd_territories_tl fttl
729: , fnd_territories ftt