eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 3149: per_all_assignments_f a,

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)
3153: AND NVL(fu.end_date, sysdate)

Line 3199: per_all_assignments_f a,

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)
3203: AND NVL(fu.end_date, sysdate)

Line 3339: per_all_assignments_f a,

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)
3343: AND NVL(fu.end_date, sysdate)