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_ASSIGNMENT_STATUS_TYPES

Line 3150: per_assignment_status_types past

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)
3154: AND fu.employee_id IS NOT NULL

Line 3200: per_assignment_status_types past

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)
3204: AND fu.employee_id IS NOT NULL

Line 3340: per_assignment_status_types past

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)
3344: AND fu.employee_id IS NOT NULL