APPS.HXC_MISSING_TCARD_REPORT dependencies on PO_VENDORS

Line 46: po_vendors pov

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
50: AND p_end_date >= a.effective_start_date

Line 89: po_vendors pov

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
93: AND p_end_date >= a.effective_start_date