APPS.HXC_DATA_SET dependencies on PER_ALL_PEOPLE_F

Line 550: per_all_people_f per

546: hxc_data_sets hds,
547: hxc_timecard_summary tsum,
548: hxc_application_sets_v has,
549: hxc_application_set_comps_v hasv,
550: per_all_people_f per
551: WHERE
552: NOT EXISTS
553: (SELECT 1
554: FROM hxc_transaction_details txnd,

Line 620: per_all_people_f per

616: nvl(per.employee_number,'Employee Number Unkown') employee_number,
617: nvl(per.full_name,'Full Name Unknown') full_name
618: FROM hxc_timecard_summary tsum,
619: hxc_data_sets d,
620: per_all_people_f per
621: WHERE tsum.approval_status ='ERROR'
622: AND per.person_id = tsum.resource_id
623: AND sysdate between per.effective_start_date and per.effective_end_date
624: AND tsum.stop_time BETWEEN d.start_date AND d.end_date

Line 644: per_all_people_f per

640: hxc_tc_ap_links tap,
641: wf_notifications wfn,
642: wf_item_activity_statuses wias,
643: wf_item_attribute_values wiav,
644: per_all_people_f per
645: WHERE tsum.approval_status = 'SUBMITTED'
646: AND per.person_id = tsum.resource_id
647: AND sysdate between per.effective_start_date and per.effective_end_date
648: AND tsum.data_set_id =p_data_set_id

Line 676: per_all_people_f per

672: hxc_app_period_summary apsum,
673: hxc_tc_ap_links tap,
674: wf_notifications wfn,
675: wf_item_activity_statuses wias,
676: per_all_people_f per
677: WHERE tsum.approval_status = 'SUBMITTED'
678: AND per.person_id = tsum.resource_id
679: AND sysdate between per.effective_start_date and per.effective_end_date
680: AND tsum.data_set_id =p_data_set_id