APPS.HXC_DATA_SET dependencies on PER_ALL_PEOPLE_F

Line 556: per_all_people_f per

552: hxc_data_sets hds,
553: hxc_timecard_summary tsum,
554: hxc_application_sets_v has,
555: hxc_application_set_comps_v hasv,
556: per_all_people_f per
557: WHERE
558: NOT EXISTS
559: (SELECT 1
560: FROM hxc_transaction_details txnd,

Line 635: per_all_people_f per

631: hxc_time_building_blocks det,
632: hxc_latest_details hld,
633: hxc_application_sets_v has,
634: hxc_application_set_comps_v hasv,
635: per_all_people_f per
636: WHERE
637: NOT EXISTS
638: (SELECT /*+ INDEX(rp HXC_RETRIEVAL_PROCESSES_PK) */
639: 1

Line 709: per_all_people_f per

705: nvl(per.employee_number,'Employee Number Unkown') employee_number,
706: nvl(per.full_name,'Full Name Unknown') full_name
707: FROM hxc_timecard_summary tsum,
708: hxc_data_sets d,
709: per_all_people_f per
710: WHERE tsum.approval_status ='ERROR'
711: AND per.person_id = tsum.resource_id
712: AND sysdate between per.effective_start_date and per.effective_end_date
713: AND tsum.stop_time BETWEEN d.start_date AND d.end_date

Line 733: per_all_people_f per

729: hxc_tc_ap_links tap,
730: wf_notifications wfn,
731: wf_item_activity_statuses wias,
732: wf_item_attribute_values wiav,
733: per_all_people_f per
734: WHERE tsum.approval_status = 'SUBMITTED'
735: AND per.person_id = tsum.resource_id
736: AND sysdate between per.effective_start_date and per.effective_end_date
737: AND tsum.data_set_id =p_data_set_id

Line 765: per_all_people_f per

761: hxc_app_period_summary apsum,
762: hxc_tc_ap_links tap,
763: wf_notifications wfn,
764: wf_item_activity_statuses wias,
765: per_all_people_f per
766: WHERE tsum.approval_status = 'SUBMITTED'
767: AND per.person_id = tsum.resource_id
768: AND sysdate between per.effective_start_date and per.effective_end_date
769: AND tsum.data_set_id =p_data_set_id