DBA Data[Home] [Help]

APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on PER_ALL_PEOPLE_F

Line 3148: per_all_people_f p,

3144:
3145: SELECT fu.user_id
3146: INTO l_user_id
3147: FROM fnd_user fu,
3148: per_all_people_f p,
3149: per_all_assignments_f a,
3150: per_assignment_status_types past
3151: WHERE fu.user_id = P_Cc_Owner_User_Id
3152: AND sysdate BETWEEN NVL(fu.start_date, sysdate)

Line 3198: per_all_people_f p,

3194:
3195: SELECT fu.user_id
3196: INTO l_user_id
3197: FROM fnd_user fu,
3198: per_all_people_f p,
3199: per_all_assignments_f a,
3200: per_assignment_status_types past
3201: WHERE fu.user_id = P_Cc_Preparer_User_Id
3202: AND sysdate BETWEEN NVL(fu.start_date, sysdate)

Line 3338: per_all_people_f p,

3334:
3335: SELECT fu.user_id
3336: INTO l_user_id
3337: FROM fnd_user fu,
3338: per_all_people_f p,
3339: per_all_assignments_f a,
3340: per_assignment_status_types past
3341: WHERE fu.user_id = P_Cc_Current_User_Id
3342: AND sysdate BETWEEN NVL(fu.start_date, sysdate)