APPS.OTA_ELIG_PROFILE_UTIL dependencies on OTA_BULK_ENR_REQ_MEMBERS

Line 906: FROM ota_bulk_enr_req_members perf

902: cursor c_person_assign_thread is
903: SELECT perf.person_id
904: ,perf.assignment_id
905: ,perf.mbr_bg_id
906: FROM ota_bulk_enr_req_members perf
907: WHERE perf.BULK_ENR_REQUEST_ID = p_action_id
908: AND perf.person_action_id BETWEEN l_start_person_action_id AND l_end_person_action_id
909: ORDER BY perf.person_action_id;
910:

Line 1121: UPDATE ota_bulk_enr_req_members

1117: END IF;
1118: END IF;
1119: END LOOP;
1120:
1121: UPDATE ota_bulk_enr_req_members
1122: SET action_status_cd = 'P'
1123: WHERE person_id = l_rec.person_id
1124: AND BULK_ENR_REQUEST_ID = p_action_id
1125: AND action_status_cd <> 'P';

Line 1129: update ota_bulk_enr_req_members set action_status_cd = 'P'

1125: AND action_status_cd <> 'P';
1126:
1127: lrnr_rec.delete;
1128: END LOOP;
1129: update ota_bulk_enr_req_members set action_status_cd = 'P'
1130: WHERE BULK_ENR_REQUEST_ID = p_action_id
1131: AND action_status_cd <> 'P'
1132: AND person_action_id BETWEEN l_start_person_action_id
1133: AND l_end_person_action_id;