DBA Data[Home] [Help]

APPS.HXC_MISSING_TCARD_REPORT dependencies on PER_ALL_PEOPLE_F

Line 45: per_all_people_f pp,

41: cursor c_vendor is
42: SELECT pov.vendor_name VENDOR_NAME,
43: a.vendor_id VENDOR_ID
44: FROM per_assignments_f a,
45: per_all_people_f pp,
46: po_vendors pov
47: WHERE a.assignment_type ='C'
48: AND a.person_id = pp.person_id
49: AND p_start_date <= a.effective_end_date

Line 88: per_all_people_f pp,

84:
85: cursor c_vendor is
86: SELECT distinct 'Y'
87: FROM per_assignments_f a,
88: per_all_people_f pp,
89: po_vendors pov
90: WHERE a.assignment_type ='C'
91: AND a.person_id = pp.person_id
92: AND p_start_date <= a.effective_end_date