DBA Data[Home] [Help]

APPS.HXC_MISSING_TCARD_REPORT dependencies on PER_ASSIGNMENTS_F

Line 44: FROM per_assignments_f a,

40:
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

Line 87: FROM per_assignments_f a,

83: Return varchar2 IS
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