DBA Data[Home] [Help]

APPS.FII_SETUP_VAL_C dependencies on HRI_CS_SUPH

Line 213: hri_cs_suph suph,

209: AND fv1.flex_value_set_id = org.org_information2
210: AND fv1.flex_value = org.org_information3
211: AND fv2.flex_value_set_id = org.org_information4
212: AND fv2.flex_value = org.org_information5) ct,
213: hri_cs_suph suph,
214: per_assignment_status_types ast
215: WHERE ct.manager = suph.sub_person_id
216: AND sysdate between suph.effective_start_date and suph.effective_end_date
217: AND suph.sup_assignment_status_type_id = ast.assignment_status_type_id

Line 600: hri_cs_suph suph,

596: sysdate + 1 ) <= sysdate
597: or nvl( fnd_date.canonical_to_date( org_information4 ),
598: sysdate + 1 ) >= sysdate)
599: and org_information2 is not null) ct,
600: hri_cs_suph suph,
601: per_assignment_status_types ast,
602: per_all_people_f per
603: where ct.org_information2 = suph.sub_person_id
604: and per.person_id = suph.sub_person_id