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_APPROVAL_WF_PKG dependencies on PER_ASSIGNMENTS_F

Line 2824: FROM per_assignments_f

2820: CURSOR c_user_pos_id IS
2821: SELECT position_id,
2822: job_id,
2823: supervisor_id
2824: FROM per_assignments_f
2825: WHERE person_id = g_approver_id
2826: AND business_group_id = g_business_group_id
2827: AND sysdate BETWEEN effective_start_date
2828: AND effective_end_date;

Line 2833: FROM per_assignments_f ass,

2829:
2830: /* Find person, using position id*/
2831: CURSOR c_pos_user_id (cpos_id NUMBER) IS
2832: SELECT pep.person_id
2833: FROM per_assignments_f ass,
2834: per_all_people_f pep
2835: WHERE position_id = cpos_id
2836: AND ass.person_id = pep.person_id
2837: AND ass.business_group_id = g_business_group_id

Line 2846: FROM per_assignments_f ass,

2842:
2843: /* Find person, using job id*/
2844: CURSOR c_job_user_id (cjob_id NUMBER) IS
2845: SELECT pep.person_id
2846: FROM per_assignments_f ass,
2847: per_all_people_f pep
2848: WHERE job_id = cjob_id
2849: AND ass.person_id = pep.person_id
2850: AND ass.business_group_id = g_business_group_id

Line 3077: FROM per_assignments_f

3073: /* Find job/position, using person id*/
3074: CURSOR c_user_pos_id IS
3075: SELECT position_id,
3076: job_id
3077: FROM per_assignments_f
3078: WHERE person_id = g_approver_id
3079: AND business_group_id = g_business_group_id
3080: AND sysdate BETWEEN effective_start_date
3081: AND effective_end_date;