890: END IF;
891: IF (x_wip_job_account IS NULL) THEN
892: BEGIN
893: SELECT FLEX_VALUE INTO x_wip_job_account
894: FROM FND_FLEX_VALUES_VL
895: WHERE FLEX_VALUE = x_destination_organization_id
896: AND (FLEX_VALUE_SET_ID = 102256);
897: EXCEPTION
898: WHEN NO_DATA_FOUND THEN
1090: END IF;
1091: IF (X_WIP_SCHEDULE_ACCOUNT IS NULL) THEN
1092: BEGIN
1093: SELECT FLEX_VALUE INTO x_wip_schedule_account
1094: FROM FND_FLEX_VALUES_VL
1095: WHERE FLEX_VALUE = x_destination_organization_id
1096: AND (FLEX_VALUE_SET_ID = 102256);
1097: EXCEPTION
1098: WHEN NO_DATA_FOUND THEN