DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_GROUP_API dependencies on PER_ASSIGNMENTS

Line 770: , per_assignments asg

766: , SUBSTR(hxc_tk_grp_query_criteria_api.get_tc_period ( p.person_id ),1,80) tc_period_name
767: , hr_person_type_usage_info.get_user_person_type(p.effective_start_date, p.person_id) person_type
768: FROM
769: per_people p
770: , per_assignments asg
771: , hr_assignment_set_amendments asa
772: , hr_assignment_sets ass
773: , per_person_types ppt --added 2943706
774: , per_person_type_usages pptu

Line 795: , per_assignments asg

791: , SUBSTR(hxc_tk_grp_query_criteria_api.get_tc_period ( p.person_id ),1,80) tc_period_name
792: , hr_person_type_usage_info.get_user_person_type(p.effective_start_date, p.person_id) person_type
793: FROM
794: per_people p
795: , per_assignments asg
796: , per_person_types ppt --added 2943706
797: , per_person_type_usages pptu
798: WHERE asg.organization_id = p_populate_id
799: AND p.person_id = asg.person_id