DBA Data[Home] [Help]

APPS.IGC_CC_APPROVAL_WF_PKG dependencies on PER_ALL_PEOPLE_F

Line 2834: per_all_people_f pep

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
2838: AND pep.business_group_id = g_business_group_id

Line 2847: per_all_people_f pep

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
2851: AND pep.business_group_id = g_business_group_id