[Home] [Help]
693: paa.business_group_id ,
694: pet.element_information1 ,
695: TO_CHAR(MAX(paa.effective_end_date), 'DD/MM/YYYY')
696: FROM per_assignments_f paa,
697: per_all_people_f pap,
698: pay_element_entries_f pee,
699: pay_element_links_f pel,
700: pay_element_types_f pet,
701: per_person_types ppt,
723: AND paa.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
724: AND TO_NUMBER(hsck.segment1) = p_gre_id
725: AND pap.effective_start_date =
726: (SELECT MAX(effective_start_date)
727: FROM per_all_people_f a,
728: per_person_types b
729: WHERE a.person_type_id = b.person_type_id
730: AND a.person_id = pap.person_id
731: AND a.business_group_id = pap.business_group_id
759: paa.business_group_id ,
760: pet.element_information1 ,
761: TO_CHAR(MAX(paa.effective_end_date), 'DD/MM/YYYY')
762: FROM per_assignments_f paa,
763: per_all_people_f pap,
764: pay_element_entries_f pee,
765: pay_element_links_f pel,
766: pay_element_types_f pet,
767: per_person_types ppt,
789: AND pap.person_id = p_person_id
790: AND paa.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
791: AND pap.effective_start_date =
792: (SELECT MAX(effective_start_date)
793: FROM per_all_people_f a,
794: per_person_types b
795: WHERE a.person_type_id = b.person_type_id
796: AND a.person_id = pap.person_id
797: AND a.business_group_id = pap.business_group_id
826: paa.business_group_id ,
827: pet.element_information1 ,
828: TO_CHAR(MAX(paa.effective_end_date), 'DD/MM/YYYY')
829: FROM per_assignments_f paa,
830: per_all_people_f pap,
831: pay_element_entries_f pee,
832: pay_element_links_f pel,
833: pay_element_types_f pet,
834: per_person_types ppt,
857: AND paa.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
858: AND TO_NUMBER(hsck.segment1) = p_gre_id
859: AND pap.effective_start_date =
860: (SELECT MAX(effective_start_date)
861: FROM per_all_people_f a,
862: per_person_types b
863: WHERE a.person_type_id = b.person_type_id
864: AND a.person_id = pap.person_id
865: AND a.business_group_id = pap.business_group_id