1033: -- OPEN c_pe(
1034: -- p_oracle_username);
1035: -- FETCH c_pe INTO v_person_id;
1036:
1037: v_person_id := FND_GLOBAL.USER_ID;
1038:
1039: BEGIN -- sub-block
1040: -- IF (c_pe%FOUND) THEN
1041: OPEN c_pp (v_person_id);
1144: -- table
1145: --OPEN c_pe(
1146: -- p_oracle_username);
1147: --FETCH c_pe INTO v_person_id;
1148: v_person_id := FND_GLOBAL.USER_ID;
1149: BEGIN -- sub-block
1150: -- IF (c_pe%FOUND) THEN
1151: OPEN c_pp (v_person_id);
1152: -- FETCH c_pp INTO v_check;